Question

Which SQL query correctly demonstrates the use of multiple LEFT JOIN clauses to combine tables authors, books, and reviews?

Accepted Answer

SELECT a.name, b.title, r.rating FROM authors a LEFT JOIN books b ON a.id = b.author_id LEFT JOIN reviews r ON b.id = r.book_id;

Answer

SELECT a.name, b.title, r.rating FROM authors a LEFT JOIN books b ON b.author_id = a.id INNER JOIN reviews r ON r.book_id = b.id;

Answer

SELECT a.name, b.title, r.rating FROM authors a INNER JOIN books b ON a.id = b.author_id LEFT JOIN reviews r ON b.id = r.book_id;

Answer

SELECT a.name, b.title, r.rating FROM authors a RIGHT JOIN books b ON a.id = b.author_id LEFT JOIN reviews r ON b.id = r.book_id;

Which SQL query correctly demonstrates the use of multiple LEFT JOIN clauses to combine tables authors, books, and reviews?

Want More Practice?