I am trying to get the average for number of Ids per day
But , some how I get "0".
Can anyone suggest
count([ID]) as No_OF_IDS,
LEFT OUTER JOIN SupplyData as S ON Proddata.Group = S.Group