How to display the maximum number of orders processed by an employee?

Question

SQL

Good day, me again.
Please help with the withdrawal of the maximum number of processed orders by an employee.
DB - www.w3schools.com/sql/trysql.asp?filename=trysql_s...
I made a query that shows the processing of each of the handlers. And the number of treatments.
And here's how to bring out the person who processed the most.
As I understand it, you must first go through COUNT and find MAX. But syntactically I can't do it.

SELECT s.SupplierName as "NameObrabot4ika",p.SupplierID as "Kolvo obrabotok"
FROM [Suppliers] s
INNER JOIN Products p ON p.SupplierID = s.SupplierID
GROUP BY s.SupplierID

Answer 1

www.sql-tutorial.ru/ru/book_aggregate_function_to_...