8.3 रकमा Small / Medium / Large मध्ये बाकेट करा

उदाहरण 1 · dataset: raja_coffee

SELECT
  CASE WHEN amount_inr >= 1000 THEN 'Large'
       WHEN amount_inr >= 600 THEN 'Medium'
       ELSE 'Small' END AS size,
  COUNT(*) AS n
FROM orders
GROUP BY 1
ORDER BY n DESC;

Output

Meaning. प्रत्येक साइज बाकेटमध्ये किती ऑर्डर्स.