Set operations
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.