Question from the SQL - Fundamentals test

Archived

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: Archived(New question!)Question passed 203 times

-1

Community Evaluations

Vincent

02/06/2023

Même si elles ne sont pas recommandées puisque moins lisible, les réponses 3 et 4 sont également valides puisque l'id 1 correspond à John Smith.

Vincent Cotro

05/06/2023

Merci Vincent, je corrige ca !