Exercise · SQL & Querying
Predict, then run it
Predict the output
members(member) = Ada, Ben, Cy. attendance(member, term) = (Ada,spring),(Cy,fall). The roster wants every member, annotating spring attendance where it exists:
SELECT m.member FROM members m LEFT JOIN attendance a ON a.member = m.member AND a.term = 'spring' ORDER BY m.member;
Predict the exact output.