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'?
Edit
10
Community EvaluationsNo one has reviewed this question yet, be the first!
16
Which SQL keyword is used to sort the result of a SELECT statement?11
How to delete an SQL table?17
Write a SQL query to insert data into a table11
Write the SQL query to delete a column from a table41
Write a SQL query to retrieve the list of employees with a salary greater than 5100.16
Update a column in an SQL table19
Select only distinct values in a column using SQL