в конце надо добавить сортировку по employee_last_name

SELECT s.last_name AS employee_last_name,
       COUNT(c.customer_id) AS all_customers
FROM staff AS s
LEFT OUTER JOIN client AS c ON s.employee_id = c.support_rep_id
GROUP BY s.employee_id
ORDER BY all_customers DESC, employee_last_name