Quiz on SQL JOIN with WHERE Clause

What does the WHERE clause do in a SQL JOIN query?

Which of the following uses JOIN with a WHERE clause correctly?

Which clause is responsible for establishing the relationship between two tables?

What does this query return?

SELECT * FROM orders o
JOIN customers c ON o.customer_id = c.customer_id
WHERE c.city = ‘Delhi’;

In older SQL syntax, how were JOINs written before the `JOIN` keyword existed?

Which is a disadvantage of using `WHERE` instead of `JOIN … ON`?

What does this query do?

SELECT * FROM emp, dept
WHERE emp.dept_id = dept.id AND emp.salary > 50000;

Which join type benefits most from WHERE clause filtering?

Can you apply filters on columns from both tables using WHERE?

Which is the correct order of clauses in a JOIN query with WHERE?

What is the output of this query if no record satisfies the WHERE condition?

SELECT * FROM A
JOIN B ON A.id = B.id
WHERE A.age > 100;

What is the main advantage of splitting JOIN and WHERE clauses?

What happens if the JOIN condition is written in the WHERE clause accidentally?

In which case should the JOIN condition **not** be placed inside WHERE clause?

Which of these best describes modern SQL JOIN usage?