Real SQL business analysis project using SELECT, JOIN, GROUP BY, HAVING and LIKE commands on Northwind retail database
Real SQL business analysis of a retail customer database using W3Schools Northwind dataset.
- Total number of customers
- Top 5 countries with most customers
- European countries customer distribution
- Cities with more than 2 customers
- Customers with names starting A to D
- Customers with more than 3 orders
- Customers who ordered in 1997
- Orders placed each year
- Shipper with most deliveries
- German customers order count
- SELECT, WHERE, ORDER BY
- GROUP BY, HAVING
- JOIN across multiple tables
- Aggregate functions COUNT, AVG, MAX, MIN
- LIKE for pattern matching
- UNION for combining results
- TOP for limiting results
- SQL
- W3Schools SQL Tryit Editor
nmujtaba01-debug Learning SQL for GIS and SAP HANA career Target: Europe and Australia