8.5 सराव: टिकट प्राधान्य आणि ऑर्डर साइज लेबल्स

उदाहरण 1 · dataset: raja_coffee

SELECT order_id, amount_inr,
  CASE WHEN amount_inr >= 1000 THEN 'Large'
       WHEN amount_inr >= 600 THEN 'Medium'
       ELSE 'Small' END AS size
FROM orders
ORDER BY amount_inr DESC
LIMIT 6;

Output

Meaning. टॉप रकमा + साइज लेबल्स.