ctreate table CHEKI(
mag char(8),
date datetime,
nomer_ch integer,
summa float)

select r.mag,sum(r.summa) as itogo,count(r.nomer_ch) as kolvo_ch from CHEKI r
where date(r.date)=date(now())
and time(r.date)<time("14:00:00")
group by r.mag

Магазин   Итого до 14    Колво чеков до 14   Итого до 17   Колво чеков до 17   Итого до 20   Колво чеков до 20
1             10                 8                 16               14
2             15                 7                 22               13
3             12                 7                 18               17