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

Predict, then run it

Predict the output

lanes(lane) = L1,L2,L3. throwers(thrower, lane) = (Ada,L1),(Ben,L3). The league sheet cross-joined them; fix to the real assignments:

SELECT l.lane, t.thrower FROM lanes l JOIN throwers t ON t.lane = l.lane ORDER BY l.lane;

Predict the exact output.