11.2 SUM and AVG on Money Columns (₹ $ £ €)

Example 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. Total and average order value in INR.

Example 2 · dataset: interview_mini

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

Output

Meaning. Separate totals per currency — do not mix.