| GameID | Title |
|---|---|
| CAT01 | Catan |
| TTR02 | Ticket to Ride |
| CAR01 | Carcassonne |
| COP01 | Codename: Pictures |
| CustomerID | FirstName | LastName | MembershipType |
|---|---|---|---|
| SMI001 | Alice | Smith | Gold |
| JON002 | David | Jones | Silver |
| LEE003 | Maya | Lee | Bronze |
| RentalID | CustomerID | GameID | FeePaid |
|---|---|---|---|
| R001 | SMI001 | CAT01 | 3.50 |
| R002 | JON002 | TTR02 | 4.00 |
| R003 | LEE003 | CAR01 | 3.00 |
| R004 | SMI001 | COP01 | 2.50 |
Alice Smith has returned the board game "Codename: Pictures" (GameID: COP01).
Complete the SQL statement to delete the rental record for the board game with GameID COP01.
DELETE FROM _____
WHERE _____
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.