Exercise · SQL & Querying
Predict, then run it
Predict the output
members(m) = m1, m2. badges(m) = m1. Members with any badge — the SELECT list inside EXISTS is irrelevant:
SELECT m FROM members WHERE EXISTS (SELECT 1 FROM badges b WHERE b.m = members.m) ORDER BY m;
Predict the exact output.