Dev Nest Guide
sqlbeginner10 minutes

Fix the SQL Syntax Error in a Basic SELECT Query

A simple SQL query has a syntax error that causes it to fail. Your task is to identify and fix the bug so that the query returns the correct results from the Employees table.

Challenge prompt

You are given a broken SQL query intended to select all employees with the job title 'Developer' from the Employees table. The query throws a syntax error and doesn't run. Find and fix the error so the query works correctly.

Guidance

  • • Check the syntax of the SELECT statement carefully.
  • • Make sure string values in the WHERE clause are properly quoted.

Hints

  • • SQL string literals should be enclosed in single quotes ' ' not double quotes " ".
  • • The WHERE clause syntax must be valid and complete.

Starter code

SELECT * FROM Employees WHERE JobTitle = "Developer";

Expected output

All rows from Employees table where JobTitle equals 'Developer'.

Core concepts

SQL SELECT statementWHERE clauseString literals in SQL

Challenge a Friend

Send this duel to someone else and see if they can solve it.