I have a table that has sales figures by booth. I want to sum up the sales for each day in one column then hav e the count of the number of booths that did not report sales in the next column (sales would be zero) This query works fine but I don't know how to add the count of the number of booths with zero sales.
Select sum(S.GrossSales) as Sales, ED.EventDaysID
From Vendordb.Booth B
Join Vendordb.Sales S on S.BoothID = B.Boothid
Join EventDays ED on ED.EventdaysID = S.EventDaysid
Where ED.EventID = 6 and B.BoothType = 2
Group by ED.EventdaysID