Joins I — semantics
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.