Toy company Second Query

PHOTO EMBED

Sat Dec 28 2024 03:24:03 GMT+0000 (Coordinated Universal Time)

Saved by @wsutanto #mysql

WITH CustomerSales AS (
	SELECT p.customerNumber, c.customerName, c.salesRepEmployeeNumber, SUM(p.amount) as total
	FROM payments p
	JOIN customers c ON p.customerNumber = c.customerNumber
	GROUP BY c.customerNumber
)
SELECT cs.salesRepEmployeeNumber, e.lastName, e.firstName, SUM(cs.total) AS total
FROM CustomerSales cs
JOIN employees e ON cs.salesRepEmployeeNumber = e.employeeNumber
GROUP BY cs.salesRepEmployeeNumber
ORDER BY total DESC
LIMIT 5;
content_copyCOPY