SQLAdvanced

Students missing a paper

PreviousProblem 40 of 40

Every student should have a final score for all 5 subjects. Return (student_id, subject_id) pairs that are missing or have no score, using EXCEPT.

Tables

fees

student_idinteger
amountinteger
due_datedate
paid_datedate

marks

student_idinteger
subject_idinteger
examvarchar
scoreinteger

students

student_idinteger
namevarchar
classvarchar
gendervarchar
dobdate
cityvarchar

subjects

subject_idinteger
subject_namevarchar

Hints(0/2)

Each hint gives a little more help. Try on your own first.

Solution

Unlocks after you solve it or after 3 submissions

SQLCtrl + Enter to run

Run your code to see the output here.