Joins II — fan-out & grain
Exercise · SQL & Querying

Predict, then run it

Predict the output

slips(slip, amount) claims one-row-per-slip, but s1 was scanned twice. Count the real slips — deduping the assumed-unique key:

SELECT COUNT(DISTINCT slip) AS slips FROM slips;

Predict the exact output.