11.1 Aggregate काय करतं (अनेक रो → एक संख्या)

By Ravindra Bagale Last updated: 31 October 2026

का (Why). Managers ना एक संख्या हवी, 10,000 रो नाहीत.

काय (What). Aggregate अनेक रो एका मूल्यात बदलतो: SUM, COUNT, AVG, MIN, MAX.

कसं (How). SELECT SUM(amount_inr) FROM orders;

पायऱ्या

उदाहरण 1 · dataset: raja_coffee

SELECT SUM(amount_inr) AS total_sales_inr,
       COUNT(*) AS order_count
FROM orders;

Output

total_sales_inr	order_count
18720.0	24

Meaning. संपूर्ण टेबलसाठी एक एकूण आणि एक संख्या.

Ravindra Bagale's Tip

Aggregates ignore row detail — use GROUP BY when you need one number per city.