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.