Database Query Challenge
Project Description:
Craft complex SQL queries to extract meaningful insights from a customer database with multiple related tables.
Use Data Mentor to run these queries
Tasks:
- Write a SQL query to find the top 10 customers by total spending.
- Create a query to identify customers who have not made any purchases in the last year.
- Generate a report showing monthly sales trends by product category.
- Develop a query to find duplicate records in the customer table and suggest a method to resolve them.
Expected Outcome:
A series of SQL scripts that demonstrate efficient data extraction and report generation capabilities.
Level:
Beginner