Why do we use aggregation functions in SQL queries?
💡 Model Answer
Aggregation functions in SQL—such as COUNT, SUM, AVG, MAX, and MIN—are used to compute summary statistics from a set of rows. They enable you to answer questions that involve totals, averages, maximum or minimum values, and counts without having to process each row individually in application code. Aggregation is essential for reporting, analytics, and data summarization. For example, a business might use SUM to calculate total revenue, AVG to find average transaction size, or COUNT to determine the number of customers. By performing these calculations directly in the database, you reduce data transfer, leverage database optimizations, and maintain a single source of truth for the summarized metrics.
This answer was generated by AI for study purposes. Use it as a starting point — personalize it with your own experience.
🎤 Get questions like this answered in real-time
Assisting AI listens to your interview, captures questions live, and gives you instant AI-powered answers — invisible to screen sharing.
Get Assisting AI — Starts at ₹500