[Solved] Find the mistake in this SQL query:SELECT c.name, o.order_date FROM customers c INNER JOIN orders o ON c.id = o.customer_id WHERE o.status = 'shipped'; | SQL

SQL - INNER JOIN

Find the mistake in this SQL query:

SELECT c.name, o.order_date FROM customers c INNER JOIN orders o ON c.id = o.customer_id WHERE o.status = 'shipped';

AMissing alias for orders table

BIncorrect alias usage in SELECT clause

CUsing WHERE instead of ON for join condition

DNo mistake, query is valid

Step-by-Step Solution

Solution:

Step 1: Check alias declarations
Aliases c and o are declared and used properly.
Step 2: Verify join and filter clauses
Join uses ON correctly; WHERE filters after join, which is correct.
Final Answer:
No mistake, query is valid -> Option D
Quick Check:
Proper alias and join syntax = Valid query [OK]

Quick Trick: ON for join, WHERE for filtering is correct [OK]

Common Mistakes:

MISTAKES

Master "INNER JOIN" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Find the mistake in this SQL query: