An exoplanet called TOI-700 d discovered in the year 2020 is to be added to the database with a PlanetID of 105.
| PlanetID | PlanetName | DiscoveryYear |
|---|---|---|
| 101 | Kepler-186f | 2014 |
| 102 | TRAPPIST-1e | 2017 |
| DiscoveryID | PlanetID | ObservatoryID |
|---|---|---|
| 701 | 101 | 9 |
| 702 | 102 | 12 |
| ObservatoryID | Name | Type |
|---|---|---|
| 9 | Kepler Space Telescope | Space |
| 12 | La Silla Observatory | Ground |
The following SQL query is run to insert this new exoplanet 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.