0001 SELECT *
0002 FROM
0003 (SELECT count(*) h8_30_to_9
0004 FROM store_sales, household_demographics, time_dim, store
0005 WHERE ss_sold_time_sk = time_dim.t_time_sk
0006 AND ss_hdemo_sk = household_demographics.hd_demo_sk
0007 AND ss_store_sk = s_store_sk
0008 AND time_dim.t_hour = 8
0009 AND time_dim.t_minute >= 30
0010 AND (
0011 (household_demographics.hd_dep_count = 4 AND household_demographics.hd_vehicle_count <= 4 + 2)
0012 OR
0013 (household_demographics.hd_dep_count = 2 AND household_demographics.hd_vehicle_count <= 2 + 2)
0014 OR
0015 (household_demographics.hd_dep_count = 0 AND
0016 household_demographics.hd_vehicle_count <= 0 + 2))
0017 AND store.s_store_name = 'ese') s1,
0018 (SELECT count(*) h9_to_9_30
0019 FROM store_sales, household_demographics, time_dim, store
0020 WHERE ss_sold_time_sk = time_dim.t_time_sk
0021 AND ss_hdemo_sk = household_demographics.hd_demo_sk
0022 AND ss_store_sk = s_store_sk
0023 AND time_dim.t_hour = 9
0024 AND time_dim.t_minute < 30
0025 AND (
0026 (household_demographics.hd_dep_count = 4 AND household_demographics.hd_vehicle_count <= 4 + 2)
0027 OR
0028 (household_demographics.hd_dep_count = 2 AND household_demographics.hd_vehicle_count <= 2 + 2)
0029 OR
0030 (household_demographics.hd_dep_count = 0 AND
0031 household_demographics.hd_vehicle_count <= 0 + 2))
0032 AND store.s_store_name = 'ese') s2,
0033 (SELECT count(*) h9_30_to_10
0034 FROM store_sales, household_demographics, time_dim, store
0035 WHERE ss_sold_time_sk = time_dim.t_time_sk
0036 AND ss_hdemo_sk = household_demographics.hd_demo_sk
0037 AND ss_store_sk = s_store_sk
0038 AND time_dim.t_hour = 9
0039 AND time_dim.t_minute >= 30
0040 AND (
0041 (household_demographics.hd_dep_count = 4 AND household_demographics.hd_vehicle_count <= 4 + 2)
0042 OR
0043 (household_demographics.hd_dep_count = 2 AND household_demographics.hd_vehicle_count <= 2 + 2)
0044 OR
0045 (household_demographics.hd_dep_count = 0 AND
0046 household_demographics.hd_vehicle_count <= 0 + 2))
0047 AND store.s_store_name = 'ese') s3,
0048 (SELECT count(*) h10_to_10_30
0049 FROM store_sales, household_demographics, time_dim, store
0050 WHERE ss_sold_time_sk = time_dim.t_time_sk
0051 AND ss_hdemo_sk = household_demographics.hd_demo_sk
0052 AND ss_store_sk = s_store_sk
0053 AND time_dim.t_hour = 10
0054 AND time_dim.t_minute < 30
0055 AND (
0056 (household_demographics.hd_dep_count = 4 AND household_demographics.hd_vehicle_count <= 4 + 2)
0057 OR
0058 (household_demographics.hd_dep_count = 2 AND household_demographics.hd_vehicle_count <= 2 + 2)
0059 OR
0060 (household_demographics.hd_dep_count = 0 AND
0061 household_demographics.hd_vehicle_count <= 0 + 2))
0062 AND store.s_store_name = 'ese') s4,
0063 (SELECT count(*) h10_30_to_11
0064 FROM store_sales, household_demographics, time_dim, store
0065 WHERE ss_sold_time_sk = time_dim.t_time_sk
0066 AND ss_hdemo_sk = household_demographics.hd_demo_sk
0067 AND ss_store_sk = s_store_sk
0068 AND time_dim.t_hour = 10
0069 AND time_dim.t_minute >= 30
0070 AND (
0071 (household_demographics.hd_dep_count = 4 AND household_demographics.hd_vehicle_count <= 4 + 2)
0072 OR
0073 (household_demographics.hd_dep_count = 2 AND household_demographics.hd_vehicle_count <= 2 + 2)
0074 OR
0075 (household_demographics.hd_dep_count = 0 AND
0076 household_demographics.hd_vehicle_count <= 0 + 2))
0077 AND store.s_store_name = 'ese') s5,
0078 (SELECT count(*) h11_to_11_30
0079 FROM store_sales, household_demographics, time_dim, store
0080 WHERE ss_sold_time_sk = time_dim.t_time_sk
0081 AND ss_hdemo_sk = household_demographics.hd_demo_sk
0082 AND ss_store_sk = s_store_sk
0083 AND time_dim.t_hour = 11
0084 AND time_dim.t_minute < 30
0085 AND (
0086 (household_demographics.hd_dep_count = 4 AND household_demographics.hd_vehicle_count <= 4 + 2)
0087 OR
0088 (household_demographics.hd_dep_count = 2 AND household_demographics.hd_vehicle_count <= 2 + 2)
0089 OR
0090 (household_demographics.hd_dep_count = 0 AND
0091 household_demographics.hd_vehicle_count <= 0 + 2))
0092 AND store.s_store_name = 'ese') s6,
0093 (SELECT count(*) h11_30_to_12
0094 FROM store_sales, household_demographics, time_dim, store
0095 WHERE ss_sold_time_sk = time_dim.t_time_sk
0096 AND ss_hdemo_sk = household_demographics.hd_demo_sk
0097 AND ss_store_sk = s_store_sk
0098 AND time_dim.t_hour = 11
0099 AND time_dim.t_minute >= 30
0100 AND (
0101 (household_demographics.hd_dep_count = 4 AND household_demographics.hd_vehicle_count <= 4 + 2)
0102 OR
0103 (household_demographics.hd_dep_count = 2 AND household_demographics.hd_vehicle_count <= 2 + 2)
0104 OR
0105 (household_demographics.hd_dep_count = 0 AND
0106 household_demographics.hd_vehicle_count <= 0 + 2))
0107 AND store.s_store_name = 'ese') s7,
0108 (SELECT count(*) h12_to_12_30
0109 FROM store_sales, household_demographics, time_dim, store
0110 WHERE ss_sold_time_sk = time_dim.t_time_sk
0111 AND ss_hdemo_sk = household_demographics.hd_demo_sk
0112 AND ss_store_sk = s_store_sk
0113 AND time_dim.t_hour = 12
0114 AND time_dim.t_minute < 30
0115 AND (
0116 (household_demographics.hd_dep_count = 4 AND household_demographics.hd_vehicle_count <= 4 + 2)
0117 OR
0118 (household_demographics.hd_dep_count = 2 AND household_demographics.hd_vehicle_count <= 2 + 2)
0119 OR
0120 (household_demographics.hd_dep_count = 0 AND
0121 household_demographics.hd_vehicle_count <= 0 + 2))
0122 AND store.s_store_name = 'ese') s8