12.4 रिपोर्टसाठी aggregate ला स्पष्ट alias

उदाहरण 1 · dataset: raja_coffee

SELECT city AS store_city,
       COUNT(*) AS order_count,
       ROUND(SUM(amount_inr),2) AS sales_inr,
       ROUND(AVG(amount_inr),2) AS avg_order_inr
FROM orders
GROUP BY city
ORDER BY sales_inr DESC;

Output

Meaning. रिपोर्ट-तयार हेडर्स.