daily
Task
Swipe to start coding
Write a SELECT statement to retrieve the title of each book and the corresponding author's name. Query the books and authors tables, returning title from books and name from authors.
Example tables:
books
| book_id | title | author_id |
|---|---|---|
| 1 | Harry Potter and the Philosopher's Stone | 1 |
| 2 | A Game of Thrones | 2 |
| 3 | The Hobbit | 3 |
authors
| author_id | name |
|---|---|
| 1 | J.K. Rowling |
| 2 | George R.R. Martin |
| 3 | J.R.R. Tolkien |
Everything was clear?
Thanks for your feedback!
SectionΒ 1. ChapterΒ 1
single
Ask AI
Ask AI
Ask anything or try one of the suggested questions to begin our chat
Suggested prompts:
Summarize this chapter
Explain the code in file
Explain why file doesn't solve the task
Congratulations!You have successfully completed the coursedaily sqldaily
Swipe to show menu
Task
Swipe to start coding
Write a SELECT statement to retrieve the title of each book and the corresponding author's name. Query the books and authors tables, returning title from books and name from authors.
Example tables:
books
| book_id | title | author_id |
|---|---|---|
| 1 | Harry Potter and the Philosopher's Stone | 1 |
| 2 | A Game of Thrones | 2 |
| 3 | The Hobbit | 3 |
authors
| author_id | name |
|---|---|
| 1 | J.K. Rowling |
| 2 | George R.R. Martin |
| 3 | J.R.R. Tolkien |
Switch to desktop for real-world practiceContinue from where you are using one of the options belowEverything was clear?
Thanks for your feedback!
SectionΒ 1. ChapterΒ 1
single
