Joins I — semantics
Exercise · SQL & Querying

Predict, then run it

Predict the output

Every member with their count of completed check-ins (zeros must show):

SELECT m.name, COUNT(c.id) FROM members m LEFT JOIN checkins c ON c.member=m.id WHERE c.status='done' GROUP BY m.name;

Predict the output for a member with no check-ins.