Question from the SQL - Fundamentals test

Write a SQL query to retrieve the titles of books written by 'John Smith'.

Easy

Given the following 'authors' and 'books' tables:

authors:
| author_id | name       |
|-----------|------------|
| 1         | John Smith |
| 2         | Jane Doe   |

books:
| book_id | title          | author_id |
|---------|----------------|-----------|
| 1       | My First Book  | 1         |
| 2       | Another Book   | 1         |
| 3       | A Great Novel  | 2         |

Which SQL query retrieves the titles of books written by 'John Smith'?

Author: Vincent CotroStatus: Published(Update)Question passed 345 times

Edit

Community Evaluations

sara

27/02/2024

SELECT title FROM books WHERE author_id = (SELECT author_id FROM authors WHERE name = 'John Smith') this one is also correct

Auteur anonyme

27/02/2024

Merci sara

Auteur anonyme

29/02/2024

Hello, n'hésitez pas à publier une version corrigée de cette question ;)