SQL_project

Advanced SQL Project using NorthWind & Airline Database | Real-world business queries solved using JOIN, CTE, Aggregation, Window Functions, and more.

SQL Project: NorthWind Business Insights

This project contains real-world SQL queries written on the NorthWind Database, designed to demonstrate data analysis, reporting, and business intelligence using SQL.

Skills & Concepts Used

• INNER JOIN / LEFT JOIN
• GROUP BY & Aggregation (SUM, COUNT, AVG, MAX, MIN)
• WHERE, ORDER BY, HAVING
• Common Table Expressions (CTE)
• WINDOW Functions (ROW_NUMBER, RANK, etc.)
• Subqueries & Aliases
• Filtering using IN, NOT IN, BETWEEN

Business Questions Solved

1. Top 5 customers based on total purchases
2. Monthly sales trend per product
3. Top selling categories
4. Orders with highest quantity
5. Customers who haven’t ordered in last 6 months
6. Employee performance by sales
7. Sales by Region using JOINs and GROUP BY
8. Use of WINDOW function to rank orders

Tools & Technology

• SQL Server / PostgreSQL / MySQL (works on all)
• NorthWind sample database

---

Let’s Connect

🔗 LinkedIn – Aman Barthria
📬 piyushsaxena7272@gmail.com