PavloSheichenko

SELECT CustomerName, OrderDate, Customers.CustomerID, Count(*) as "Number Of Orders"
FROM Customers
JOIN Orders
USING (CustomerID)
Group by CustomerName, CustomerID, OrderDate
HAVING Count(*)> 1