I am working with a Select Query (SQL Server 2000) where I want to filter for the number of orders being placed for a specific item. For the Query below
I want to bring back only customers who placed an order for ItemCode='100' more than two times. Any ideas on how I can do this? Thanks.
JOIN Orders on Customer.CustomerID = Orders.CustomerID