A marine biology research station has a database that records telemetry data each time a marine animal's satellite tag transmits. The record format is given in the table below:
| Fieldname | Description |
|---|---|
| LogDate | The date the telemetry reading was taken |
| TagID | The unique ID of the transmitter tag |
| Species | The species category – Shark, Whale, or Turtle |
| Depth | The depth in meters recorded by the tag |
The telemetry log is stored in a database table called tag_telemetry. The current contents of tag_telemetry are shown:
| LogDate | TagID | Species | Depth |
|---|---|---|---|
| 15/04/2024 | SK_102 | Shark | 85 |
| 15/04/2024 | WL_504 | Whale | 240 |
| 16/04/2024 | TT_081 | Turtle | 12 |
| 16/04/2024 | SK_102 | Shark | 115 |
| 17/04/2024 | WL_504 | Whale | 310 |
| 17/04/2024 | SK_201 | Shark | 195 |
| 18/04/2024 | TT_081 | Turtle | 45 |
Write an SQL statement to display the tag IDs of the shark species that have recorded a depth of more than 100 meters.
5 exam-style questions on OCR GCSE Computer Science Additional programming techniques. Each one has a worked solution and a mark scheme showing where the marks go.