MySQL Tutorial - Aggregate Functions
📊 Aggregate - Calculate Karo
Calculations:
💰 Total sales
📊 Average marks
🔢 Count users
📈 Maximum price
Functions
| Function | Use |
|---|---|
| COUNT() | Count rows |
| SUM() | Total |
| AVG() | Average |
| MAX() | Maximum |
| MIN() | Minimum |
Example
SELECT COUNT(*) FROM products;
SELECT AVG(price) FROM products;