All pastes #343911 Raw Edit

Unnamed

public text v1 · immutable
·published 2007-02-07 11:23 UTC
rendered paste body
SELECT CompanyName, Customers.CustomerID, COUNT([Order Details].OrderID) AS Num FROM Customers,Orders,[Order Details]
WHERE Orders.CustomerID = Customers.CustomerID
AND Orders.OrderID = [Order Details].OrderID
GROUP BY [Order Details].OrderID, CompanyName, Customers.CustomerID HAVING COUNT([Order Details].OrderID) > 5;