use gala_shop

go
 Select
 ArhivCHJekKKM._Date_Time As DocDate ,
     Podrazdeleniyaaa._Description As Shop ,
     Count ( Distinct ArhivCHJekKKM._IDRRef ) As Number
 From
     _Document177 As OtchjetORoznichjnjhProdazhhhah
     Inner Join _Document7888 As ArhivCHJekKKM
         On OtchjetORoznichjnjhProdazhhhah._Fld3734RRef = ArhivCHJekKKM._Fld7891RRef
     Inner Join _Reference68 As Podrazdeleniyaaa
         On OtchjetORoznichjnjhProdazhhhah._Fld3740RRef = Podrazdeleniyaaa._IDRRef
 Where
     OtchjetORoznichjnjhProdazhhhah._Date_Time Between '30/09/2010 00:00:00' And '01/10/2010 00:00:00' And
     ArhivCHJekKKM._Date_Time Between '30/09/2010 00:00:00' And '01/10/2010 00:00:00'
 Group By
     Podrazdeleniyaaa._Description,
     ArhivCHJekKKM._Date_Time