Structured query language (SQL)

EasyMediumHard
1234567
Question 6
Hard

A flight training academy needs to produce a report listing the trainees who have successfully completed the 'Solo Cross-Country' milestone. The report must include both names of each trainee and the date they completed this milestone.

Trainee

TraineeIDGivenNameSurNameDateEnrolled
T201MalikAl-Jamil2023-01-12
T202FionaGallagher2023-02-18
T203HiroshiTanaka2023-03-05
T204ElenaRostova2023-04-10

Milestone

LogIDTraineeIDDateCompletedMilestoneName
501T2012023-03-22Solo Flight
502T2012023-05-14Solo Cross-Country
503T2032023-04-18Solo Flight
504T2022023-06-02Solo Cross-Country

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

[6]

Structured query language (SQL) Questions

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