Exercise · SQL & Querying
Predict, then run it
Predict the output
batches(batch, cure_days) = (b1,60),(b2,30),(b3,10). Grade by cure time — premium ≥ 45, standard ≥ 20, else quick:
SELECT batch, CASE WHEN cure_days >= 45 THEN 'premium' WHEN cure_days >= 20 THEN 'standard' ELSE 'quick' END AS grade FROM batches ORDER BY batch;
Predict the exact output.