Back to home page

OSCL-LXR

 
 

    


0001 SELECT count(*)
0002 FROM store_sales, household_demographics, time_dim, store
0003 WHERE ss_sold_time_sk = time_dim.t_time_sk
0004   AND ss_hdemo_sk = household_demographics.hd_demo_sk
0005   AND ss_store_sk = s_store_sk
0006   AND time_dim.t_hour = 20
0007   AND time_dim.t_minute >= 30
0008   AND household_demographics.hd_dep_count = 7
0009   AND store.s_store_name = 'ese'
0010 ORDER BY count(*)
0011 LIMIT 100