| DroneID | Model |
|---|---|
| DR001 | Phantom-X |
| DR002 | Matrix-V |
| DR003 | SkyRider |
| DR004 | Aeroscope |
| PilotID | FirstName | LastName | LicenseClass |
|---|---|---|---|
| PIL01 | Sarah | Connor | Gold |
| PIL02 | John | Miller | Silver |
| PIL03 | Elena | Rostova | Bronze |
| MissionID | PilotID | DroneID | DistanceKM |
|---|---|---|---|
| M101 | PIL01 | DR001 | 12.50 |
| M102 | PIL02 | DR002 | 8.00 |
| M103 | PIL03 | DR003 | 15.00 |
| M104 | PIL01 | DR004 | 5.50 |
Sarah Connor has completed her flight using the drone "Aeroscope" (DroneID: DR004).
Complete the SQL statement to delete the mission record for the drone with DroneID DR004.
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.