Exercise · SQL & Querying
Predict, then run it
Predict the output
morning(item, torque) = (K1,4.2),(K2,NULL),(K3,4.5). evening(item, torque) = (K1,4.2),(K2,NULL). Items the morning check has that the evening one doesn't:
SELECT item, torque FROM morning EXCEPT SELECT item, torque FROM evening ORDER BY item;
Predict the exact output.