Missing counts as zero — SQL practice · JobPrax

Practice
Live projects
Guided projects
For colleges
Pricing

Log in Start free

SQLBasic

Missing counts as zero

PreviousProblem 18 of 40Next

For student 15, show subject_id, exam and score_or_zero (the score, or 0 when missing).

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

Log in to save progress and earn XP

Run your code to see the output here.