Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance. Project price only 1 $
You can buy this project and download/modify it how often you want.
-- database: presto_tpcds; groups: tpcds; requires: io.prestodb.tempto.fulfillment.table.hive.tpcds.ImmutableTpcdsTablesRequirements
SELECT *
FROM
(
SELECT "count"(*) "h8_30_to_9"
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" = 8)
AND ("time_dim"."t_minute" >= 30)
AND ((("household_demographics"."hd_dep_count" = 4)
AND ("household_demographics"."hd_vehicle_count" <= (4 + 2)))
OR (("household_demographics"."hd_dep_count" = 2)
AND ("household_demographics"."hd_vehicle_count" <= (2 + 2)))
OR (("household_demographics"."hd_dep_count" = 0)
AND ("household_demographics"."hd_vehicle_count" <= (0 + 2))))
AND ("store"."s_store_name" = 'ese')
) s1
, (
SELECT "count"(*) "h9_to_9_30"
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" = 9)
AND ("time_dim"."t_minute" < 30)
AND ((("household_demographics"."hd_dep_count" = 4)
AND ("household_demographics"."hd_vehicle_count" <= (4 + 2)))
OR (("household_demographics"."hd_dep_count" = 2)
AND ("household_demographics"."hd_vehicle_count" <= (2 + 2)))
OR (("household_demographics"."hd_dep_count" = 0)
AND ("household_demographics"."hd_vehicle_count" <= (0 + 2))))
AND ("store"."s_store_name" = 'ese')
) s2
, (
SELECT "count"(*) "h9_30_to_10"
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" = 9)
AND ("time_dim"."t_minute" >= 30)
AND ((("household_demographics"."hd_dep_count" = 4)
AND ("household_demographics"."hd_vehicle_count" <= (4 + 2)))
OR (("household_demographics"."hd_dep_count" = 2)
AND ("household_demographics"."hd_vehicle_count" <= (2 + 2)))
OR (("household_demographics"."hd_dep_count" = 0)
AND ("household_demographics"."hd_vehicle_count" <= (0 + 2))))
AND ("store"."s_store_name" = 'ese')
) s3
, (
SELECT "count"(*) "h10_to_10_30"
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" = 10)
AND ("time_dim"."t_minute" < 30)
AND ((("household_demographics"."hd_dep_count" = 4)
AND ("household_demographics"."hd_vehicle_count" <= (4 + 2)))
OR (("household_demographics"."hd_dep_count" = 2)
AND ("household_demographics"."hd_vehicle_count" <= (2 + 2)))
OR (("household_demographics"."hd_dep_count" = 0)
AND ("household_demographics"."hd_vehicle_count" <= (0 + 2))))
AND ("store"."s_store_name" = 'ese')
) s4
, (
SELECT "count"(*) "h10_30_to_11"
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" = 10)
AND ("time_dim"."t_minute" >= 30)
AND ((("household_demographics"."hd_dep_count" = 4)
AND ("household_demographics"."hd_vehicle_count" <= (4 + 2)))
OR (("household_demographics"."hd_dep_count" = 2)
AND ("household_demographics"."hd_vehicle_count" <= (2 + 2)))
OR (("household_demographics"."hd_dep_count" = 0)
AND ("household_demographics"."hd_vehicle_count" <= (0 + 2))))
AND ("store"."s_store_name" = 'ese')
) s5
, (
SELECT "count"(*) "h11_to_11_30"
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" = 11)
AND ("time_dim"."t_minute" < 30)
AND ((("household_demographics"."hd_dep_count" = 4)
AND ("household_demographics"."hd_vehicle_count" <= (4 + 2)))
OR (("household_demographics"."hd_dep_count" = 2)
AND ("household_demographics"."hd_vehicle_count" <= (2 + 2)))
OR (("household_demographics"."hd_dep_count" = 0)
AND ("household_demographics"."hd_vehicle_count" <= (0 + 2))))
AND ("store"."s_store_name" = 'ese')
) s6
, (
SELECT "count"(*) "h11_30_to_12"
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" = 11)
AND ("time_dim"."t_minute" >= 30)
AND ((("household_demographics"."hd_dep_count" = 4)
AND ("household_demographics"."hd_vehicle_count" <= (4 + 2)))
OR (("household_demographics"."hd_dep_count" = 2)
AND ("household_demographics"."hd_vehicle_count" <= (2 + 2)))
OR (("household_demographics"."hd_dep_count" = 0)
AND ("household_demographics"."hd_vehicle_count" <= (0 + 2))))
AND ("store"."s_store_name" = 'ese')
) s7
, (
SELECT "count"(*) "h12_to_12_30"
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" = 12)
AND ("time_dim"."t_minute" < 30)
AND ((("household_demographics"."hd_dep_count" = 4)
AND ("household_demographics"."hd_vehicle_count" <= (4 + 2)))
OR (("household_demographics"."hd_dep_count" = 2)
AND ("household_demographics"."hd_vehicle_count" <= (2 + 2)))
OR (("household_demographics"."hd_dep_count" = 0)
AND ("household_demographics"."hd_vehicle_count" <= (0 + 2))))
AND ("store"."s_store_name" = 'ese')
) s8
