Something
public text v1 · immutable/*
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;
/*
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;