Same project but new query. Client wants a report on how many sales per coupon. I figured out the sum of money, but not sure how to get a count on the number of sales. I found a thread online that pointed me to COUNT and I tried this but it is wrong. Any advice most appreciated. The order tracking number is where the coupon name is stored.
SELECT COUNT (DISTINCT OrderTrackingNumber)
WHERE OrderTrackingNumber = 'FH1409'