Exercise · SQL & Querying
Predict, then run it
Predict the output
morning(sp) = a, a, b. afternoon(sp) = a. The honest remainder after one departure — keeping the duplicate resident:
SELECT sp FROM morning EXCEPT ALL SELECT sp FROM afternoon ORDER BY sp;
Predict the exact output.