TDS Assignments | IIT Madras - Tools in Data Science Graded Assignments Answers

📊 SQL Query Generator: Business Analysis

Select Business Use Case

Date Range Filter

🧠 Task: find the top 5 customers by total purchase amount

📦 Tables: customers, orders, order_items, products

⚙️ Requirements: join orders with customers, calculate total spent per customer

📄 Generated SQL Query

SELECT c.customer_id, c.name, SUM(oi.quantity * oi.unit_price) AS total_spent
FROM customers c
JOIN orders o ON c.customer_id = o.customer_id
JOIN order_items oi ON o.order_id = oi.order_id
WHERE o.order_date >= DATE_SUB(CURDATE(), INTERVAL 30 DAY)
GROUP BY c.customer_id, c.name
ORDER BY total_spent DESC
LIMIT 5;