An oceanographic expedition called Albatross from the year 2024 is to be added to the database with an ExpeditionID of 805.
| ExpeditionID | CodeName | YearLaunched |
|---|---|---|
| 801 | Nautilus | 2018 |
| 802 | Challenger | 2021 |
| AssignmentID | ExpeditionID | ScientistID |
|---|---|---|
| 901 | 801 | 42 |
| 902 | 802 | 42 |
| ScientistID | FirstName | LastName |
|---|---|---|
| 42 | Sylvia | Earle |
The following SQL query is run to insert this new expedition into the database:
INSERT INTO P
Q ( R )
Some parts of the SQL query have been replaced by the labels P, Q, and R.
State the SQL terms or values that should have been written in place of the labels P, Q, and R.
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.