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