A list of all payloads of the 'Satellite' type is needed from the database.
| PayloadID | Name | Type | MassKG |
|---|---|---|---|
| PL-101 | Sentinel-6 | Satellite | 1192 |
| PL-102 | Dragon-C201 | Cargo Capsule | 4200 |
| PL-103 | Hubble-Up | Satellite | 11110 |
| LaunchID | PayloadID | LaunchVehicleID | LaunchDate |
|---|---|---|---|
| L-901 | PL-101 | LV-05 | 2020-11-21 |
| L-902 | PL-102 | LV-09 | 2021-05-03 |
| LaunchVehicleID | Model | Agency | | :--- | :--- | :--- | :--- | | LV-05 | Falcon 9 | SpaceX | | LV-09 | Falcon Heavy | SpaceX |
The following SQL query is run to produce the list:
A PayloadID, Name, MassKG FROM Payload WHERE B
Some parts of the SQL query have been replaced by labels A and B.
State the SQL statements or clauses that should have been written in place of the labels A and B.
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.