I completed this project by first designing a sales database with three tables: customers, products, and sales. I inserted sample Indian names and realistic product data, then added transactions across multiple dates. Using SQL queries with JOIN, GROUP BY, and aggregate functions like SUM, AVG, and COUNT, I generated reports such as daily sales totals, average transaction values, top products by revenue, customer spending, number of transactions per day, and product sales trends. While working, I faced small challenges with foreign keys and calculations but solved them by refining insert values and using functions like ROUND(). Through this project, I learned how to design a normalized database, use aggregate functions, and prepare real-world business reports using SQL.