11.2 पैशाच्या कॉलमवर SUM आणि AVG

उदाहरण 1 · dataset: raja_coffee

SELECT ROUND(SUM(amount_inr),2) AS total_inr,
       ROUND(AVG(amount_inr),2) AS avg_inr
FROM orders;

Output

Meaning. INR मध्ये एकूण आणि सरासरी ऑर्डर मूल्य.

उदाहरण 2 · dataset: interview_mini

SELECT currency, ROUND(SUM(amount),2) AS total
FROM sales
GROUP BY currency
ORDER BY currency;

Output

Meaning. प्रत्येक currency वेगळी बेरीज — मिस करू नका.