sql-aggregation-analysis

SQL aggregation functions practice with real-world business questions

SQL Aggregation Functions Analysis

This project contains SQL queries practiced as part of learning aggregation functions using real-world business-style questions.

Topics Covered

• COUNT, SUM, AVG, ROUND
• GROUP BY (single & multiple columns)
• HAVING clause
• ORDER BY
• COALESCE
• ALTER TABLE

Sample Business Questions

• Count customer records in the database
• Find average product price
• Identify regions with high customer count
• Analyze payment trends by date and method
• Find high-value customers using HAVING

Tables Used

• customers
• products
• orders
• payment
• order_items

Tools Used

• MySQL

Project Level

Beginner – SQL Fundamentals