A book called Othello from the year 1622 is to be added to the database with a BookID of 204.
| BookID | Title | PublishedYear |
|---|---|---|
| 201 | Hamlet | 1603 |
| 202 | Macbeth | 1623 |
| WritingID | BookID | AuthorID |
|---|---|---|
| 501 | 201 | 15 |
| 502 | 202 | 15 |
| AuthorID | Firstname | Lastname |
|---|---|---|
| 15 | William | Shakespeare |
The following SQL query is run to insert this new book into the database:
INSERT INTO X
Y ( Z )
Some parts of the SQL query have been replaced by the labels X, Y, and Z.
State the SQL terms or values that should have been written in place of the labels X, Y, and Z.
25 exam-style questions on AQA GCSE Computer Science Structured query language (SQL). Each one has a worked solution and a mark scheme showing where the marks go.