Анатолий

with tt as (
select ID_Customer id, id_store,  date_trunc('hour', date_transactions) trun 
from transactions t
)
select id,  id_store, count(id)
from tt
group by 1,2