| ExpeditionID | LocationCode | DurationDays |
|---|---|---|
| 401 | ARC-A | 14 |
| 402 | PAC-F | 21 |
| 403 | IND-S | 10 |
| SightingID | ExpeditionID | SpeciesID |
|---|---|---|
| 7001 | 401 | 15 |
| 7002 | 402 | 15 |
| 7003 | 403 | 18 |
| SpeciesID | CommonName | ConservationStatus |
|---|---|---|
| 15 | Blue Whale | Endangered |
| 18 | Humpback Whale | Vulnerable |
The conservation status for the species Blue Whale has been reclassified. It needs to be updated from Endangered to Critically Endangered in the database.
Write the SQL statement to perform this update.
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.