04B
Compare these references after your own attempt. You can read them at any time; they do not record a live model or vendor run.
Compare these references after your own attempt. You can read them at any time; they do not record a live model or vendor run.
-- 04b: Make a March flag
SELECT order_id,CASE WHEN order_date>=DATE '2025-03-01'
AND order_date<DATE '2025-04-01' THEN 1 ELSE 0 END AS in_march
FROM aabha_sql.orders WHERE order_id IN (1008,1009,1012) ORDER BY order_id;