Exercise · SQL & Querying
Predict, then run it
Predict the output
shows(id, fee) = (1,100); sales(show_id) = 1,1 (two sales). Summing the fee across the join:
SELECT SUM(fee) FROM shows s JOIN sales x ON x.show_id=s.id;
Predict the exact output.
shows(id, fee) = (1,100); sales(show_id) = 1,1 (two sales). Summing the fee across the join:
SELECT SUM(fee) FROM shows s JOIN sales x ON x.show_id=s.id;
Predict the exact output.