SQL queries to explore and analyze sales, customers, and product data from a retail database. Includes key business insights like total revenue, customer demographics, product performance, and sales trends. This project contains a collection of SQL queries used to explore and analyze data from a sales and customer database using Microsoft SQL Server. The queries help answer essential business questions such as:
Which countries and genders dominate the customer base?
What are the top-selling and lowest-performing products?
Who are the highest revenue-generating customers?
What is the total and average revenue, order volume, and price trends?
The queries also include metadata exploration using INFORMATION_SCHEMA, as well as summary reports combining key business metrics.