/*
Cliente che hanno fatto piu ordini
*/

SELECT TOP 1 CompanyName, COUNT(*) as Num FROM Customers, Orders
WHERE Orders.CustomerID = Customers.CustomerID
GROUP BY CompanyName
ORDER BY Num DESC;