Conditional logic & CASE
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.