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.
Practise AQA GCSE Computer Science Structured query language (SQL) with exam-style questions for GCSE Computer Science. 25 questions, matched to the AQA GCSE Computer Science (8525) specification and written in Paper 1 and Paper 2 style. Every question includes a full worked solution and mark scheme, so you can see where marks are awarded rather than just whether you got the answer right.