text: select count(*) as ct
  from store_sales
      JOIN household_demographics ON store_sales.ss_hdemo_sk = household_demographics.hd_demo_sk
      JOIN time_dim ON store_sales.ss_sold_time_sk = time_dim.t_time_sk
      JOIN store ON store_sales.ss_store_sk = store.s_store_sk
  where
          time_dim.t_hour = 8
      and time_dim.t_minute >= 30
      and household_demographics.hd_dep_count = 7
      and store.s_store_name = 'ese'
  order by ct
  limit 100;
  
  