Kursusindhold
daily sql
daily sql
daily
Opgave
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 |
Skift til skrivebord for at øve i den virkelige verdenFortsæt der, hvor du er, med en af nedenstående mulighederVar alt klart?
Tak for dine kommentarer!
Sektion 1. Kapitel 1
daily
Opgave
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 |
Skift til skrivebord for at øve i den virkelige verdenFortsæt der, hvor du er, med en af nedenstående mulighederVar alt klart?
Tak for dine kommentarer!
Sektion 1. Kapitel 1
Skift til skrivebord for at øve i den virkelige verdenFortsæt der, hvor du er, med en af nedenstående muligheder