Dev Nest Guide
sqlbeginner10 minutes

Fix the Incorrect SQL Query Filtering by Date

Identify and fix the bug in the provided SQL query that aims to filter orders placed after January 1, 2023. The original query incorrectly returns all rows due to a syntax mistake in the WHERE clause.

Challenge prompt

You are given a SQL query intended to select all orders made after January 1st, 2023 from the 'Orders' table. However, the current query returns all orders regardless of the order date. Find the bug and fix the query so it correctly filters the results.

Guidance

  • • Check the syntax of the WHERE clause and ensure the date comparison operator is used correctly.
  • • Verify how date literals are formatted in SQL and whether they are quoted properly.

Hints

  • • In SQL, date values should be enclosed in single quotes.
  • • Make sure you are using a comparison operator (>, >=, etc.) correctly with the column name and date.

Starter code

SELECT * FROM Orders WHERE OrderDate > 2023-01-01;

Expected output

Only orders with OrderDate after 2023-01-01 should be returned.

Core concepts

WHERE clauseDate comparisonSQL syntax

Challenge a Friend

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