Structured query language (SQL)

EasyMediumHard
1234567
Question 4
Hard

A marine research station needs to produce a report listing the biologists who have successfully completed a dive in the 'Abyssal' depth zone. The report must include the given name and surname of each biologist, and the specific date of the dive.

Biologist

BiologistIDGivenNameSurNameCertificationDate
201ElenaRostova2020-05-12
202MarcusVance2021-02-18
203PriyaSharma2021-08-05
204KenjiSato2022-11-30

ResearchDive

DiveIDBiologistIDDiveDateDepthZone
8012012021-07-14Bathyal
8022012022-09-05Abyssal
8032032022-03-22Pelagic
8042042023-01-11Abyssal
8052012023-06-18Abyssal

Write an SQL query that could be used to retrieve this information. The results must be ordered by the date of the dive, starting with the most recent dive first.

[6]

Structured query language (SQL) Questions

  1. GCSE
  2. /Computer Science
  3. /Structured query language (SQL)