E-commerce Database

Tables: Customers, Orders, Products, OrderDetails, Payments.

• Tasks:
  • Find top 5 customers by spending.
  • Most sold product.
  • Monthly revenue report.

SELECT c.CustomerName, SUM(o.TotalAmount) AS TotalSpent
FROM Customers c
JOIN Orders o ON c.CustomerID = o.CustomerID
GROUP BY c.CustomerName
ORDER BY TotalSpent DESC
LIMIT 5;