sele sk_fin
copy for left(id_kas, 1) = "H" to hacka
use hacka
repl all u_open with left(u_open, 2)
repl all uzaverka with left(uzaverka, 6) + "  " + u_open
sele id_kas, uzaverka, cnt(*) as pocet group by 1,2 from hacka into table hacka_po_hodinach
brow
copy all to hacka_po_hodinach type xls
*clos data
