Subqueries & CTEs
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.