Structured query language (SQL)

EasyMediumHard
1234567
Question 1
Hard

A music school needs to produce a report listing the students who have successfully achieved the 'Grade 5' qualification. The report must include both names of each student and the date they achieved this grade.

Student

StudentIDFirstNameLastNameDateEnrolled
101AmaraPatel2021-09-01
102BenjaminSmith2021-10-15
103ChloeDubois2022-01-10
104DanielZhang2022-03-22

GradePassed

ExamIDStudentIDDateAchievedGradeLevel
11012022-06-15Grade 3
21012023-05-20Grade 5
31032022-12-18Grade 1
41022023-01-15Grade 5

Write an SQL query that could be used to retrieve this information. The results must be ordered by the date the grades were achieved, starting with the earliest date first.

[6]

Structured query language (SQL) Questions

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