| ==== | |
| ---- QUERY: TPCDS-Q96 | |
| select count(*) as total | |
| from store_sales, | |
| household_demographics, | |
| time_dim, | |
| store | |
| where ss_sold_time_sk = time_dim.t_time_sk | |
| and ss_hdemo_sk = household_demographics.hd_demo_sk | |
| and ss_store_sk = s_store_sk | |
| and time_dim.t_hour = 20 | |
| and time_dim.t_minute >= 30 | |
| and household_demographics.hd_dep_count = 7 | |
| and store.s_store_name = 'ese' | |
| order by total | |
| limit 100; | |
| ---- RESULTS | |
| 870 | |
| ---- TYPES | |
| BIGINT | |
| ==== |