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.
Practise OCR GCSE Computer Science Programming fundamentals with exam-style questions for GCSE Computer Science. 100 questions, matched to the OCR GCSE Computer Science (J277) specification and written in Component 01 and Component 02 style. Every question includes a full worked solution and mark scheme, so you can see where marks are awarded rather than just whether you got the answer right.