Due to temporary maintenance in Room 1 of the veterinary clinic, the room is not suitable for procedures involving animals with a maximum weight of more than 40 kg.
The clinic manager needs to find out the owner's last name, date, and appointment time for all bookings made in Room 1 for treatments where the maximum weight of the animal can exceed 40 kg.
Study the database schema below and write an SQL query to retrieve this information. The results must be displayed in date order.
| TreatmentName | TargetSpecies | MinAgeWeeks | MaxWeightKg | Price |
|---|---|---|---|---|
| Rabies Vaccine | Dog | 12 | 80 | 45.00 |
| Flea Treatment | Cat | 8 | 15 | 15.00 |
| Microchipping | Dog | 6 | 90 | 25.00 |
| Dental Clean | Cat | 52 | 12 | 120.00 |
| Spaying | Dog | 24 | 40 | 200.00 |
| RoomNo | TreatmentName | AppDate | AppTime | OwnerLastName | VetName |
|---|---|---|---|---|---|
| 1 | Rabies Vaccine | 12/10/24 | 09:00 | Smith | Dr. Evans |
| 2 | Flea Treatment | 12/10/24 | 10:30 | Patel | Dr. Green |
| 1 | Spaying | 12/10/24 | 11:00 | Jones | Dr. Evans |
| 3 | Dental Clean | 13/10/24 | 14:00 | Wong | Dr. Evans |
| 1 | Microchipping | 13/10/24 | 09:30 | Smith | Dr. Green |
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.