mirror of
https://github.com/hanzoai/datastore.git
synced 2026-09-26 13:55:07 +00:00
12 lines
393 B
SQL
12 lines
393 B
SQL
SELECT count(*)
|
|
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 count(*)
|
|
LIMIT 100;
|