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