SELECT t.time_band, count(1) order_cnt
FROM fact_order f JOIN dim_time t ON f.time_key = t.time_key
WHERE f.dt = '2026-10-11'
GROUP BY t.time_band;