| SpeciesID | CommonName | ConservationStatus |
|---|---|---|
| SP01 | Golden Eagle | Vulnerable |
| SP02 | Red Panda | Endangered |
| SP03 | Amur Leopard | Critically Endangered |
| AnimalID | SpeciesID | Nickname |
|---|---|---|
| A81 | SP01 | Aquila |
| A82 | SP02 | Rusty |
| A83 | SP03 | Kasha |
| TreatmentID | AnimalID | Cost |
|---|---|---|
| T91 | A81 | 450.00 |
| T92 | A82 | 120.00 |
| T93 | A83 | 45.00 |
The species with the common name Red Panda has been reclassified. Its conservation status has been incorrectly entered as Endangered and must be updated to Critically Endangered.
Write an SQL statement to make this change.
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.