| ==== |
| ---- QUERY: TPCDS-Q7 |
| select |
| i_item_id, |
| avg(ss_quantity) agg1, |
| avg(ss_list_price) agg2, |
| avg(ss_coupon_amt) agg3, |
| avg(ss_sales_price) agg4 |
| from |
| store_sales, |
| customer_demographics, |
| date_dim, |
| item, |
| promotion |
| where |
| ss_sold_date_sk = d_date_sk |
| and ss_item_sk = i_item_sk |
| and ss_cdemo_sk = cd_demo_sk |
| and ss_promo_sk = p_promo_sk |
| and cd_gender = 'M' |
| and cd_marital_status = 'S' |
| and cd_education_status = 'College' |
| and (p_channel_email = 'N' |
| or p_channel_event = 'N') |
| and d_year = 2000 |
| group by |
| i_item_id |
| order by |
| i_item_id |
| limit 100; |
| ---- RESULTS |
| 'AAAAAAAAAAACAAAA',17,13.150000,7.700000,1.970000 |
| 'AAAAAAAAAAAEAAAA',99,123.440000,0.000000,44.430000 |
| 'AAAAAAAAAABBAAAA',11,77.310000,0.000000,38.650000 |
| 'AAAAAAAAAABEAAAA',35.5,18.900000,0.000000,4.850000 |
| 'AAAAAAAAAACAAAAA',61,38.630000,90.245000,16.385000 |
| 'AAAAAAAAAACCAAAA',10.5,83.465000,0.000000,30.020000 |
| 'AAAAAAAAAADBAAAA',44,108.360000,0.000000,13.000000 |
| 'AAAAAAAAAADCAAAA',54,59.290000,0.000000,34.980000 |
| 'AAAAAAAAAADEAAAA',93,43.570000,0.000000,38.340000 |
| 'AAAAAAAAAAEAAAAA',72,16.460000,0.000000,13.330000 |
| 'AAAAAAAAAAEBAAAA',88,29.020000,0.000000,0.870000 |
| 'AAAAAAAAAAEDAAAA',91,84.375000,0.000000,9.090000 |
| 'AAAAAAAAAAFDAAAA',37,33.130000,0.000000,20.200000 |
| 'AAAAAAAAAAGEAAAA',35,56.480000,881.450000,23.630000 |
| 'AAAAAAAAAAHDAAAA',33,59.050000,0.000000,48.530000 |
| 'AAAAAAAAAAICAAAA',68.5,108.730000,166.780000,69.220000 |
| 'AAAAAAAAAAIDAAAA',76,97.190000,0.000000,43.730000 |
| 'AAAAAAAAAAJCAAAA',30,47.550000,0.000000,30.430000 |
| 'AAAAAAAAAAKBAAAA',59,55.080000,0.000000,17.070000 |
| 'AAAAAAAAAAMBAAAA',74,10.390000,0.000000,8.620000 |
| 'AAAAAAAAAAMCAAAA',86,24.100000,0.410000,0.480000 |
| 'AAAAAAAAAANAAAAA',43,80.160000,0.000000,41.680000 |
| 'AAAAAAAAAANBAAAA',28,112.270000,0.000000,57.250000 |
| 'AAAAAAAAAAOAAAAA',46,12.630000,0.000000,4.670000 |
| 'AAAAAAAAAAPBAAAA',66,39.590000,969.800000,18.600000 |
| 'AAAAAAAAAAPCAAAA',90,68.280000,0.000000,47.790000 |
| 'AAAAAAAAABAAAAAA',10.5,71.480000,0.000000,28.920000 |
| 'AAAAAAAAABABAAAA',12.5,100.530000,2.230000,34.807500 |
| 'AAAAAAAAABADAAAA',100,68.670000,0.000000,50.810000 |
| 'AAAAAAAAABAEAAAA',49,15.790000,0.000000,11.840000 |
| 'AAAAAAAAABBCAAAA',52,115.100000,0.000000,24.170000 |
| 'AAAAAAAAABDEAAAA',92,168.960000,0.000000,23.650000 |
| 'AAAAAAAAABEAAAAA',33.33333333333334,58.646667,99.473333,22.166667 |
| 'AAAAAAAAABECAAAA',43,167.740000,0.000000,88.900000 |
| 'AAAAAAAAABEDAAAA',74,129.100000,0.000000,108.440000 |
| 'AAAAAAAAABFBAAAA',36,115.180000,0.000000,109.420000 |
| 'AAAAAAAAABFCAAAA',51,121.980000,0.000000,17.070000 |
| 'AAAAAAAAABFEAAAA',65,117.880000,0.000000,107.270000 |
| 'AAAAAAAAABGBAAAA',52,71.545000,0.000000,30.285000 |
| 'AAAAAAAAABGDAAAA',67.5,58.860000,0.000000,35.250000 |
| 'AAAAAAAAABHAAAAA',71,39.385000,804.375000,8.380000 |
| 'AAAAAAAAABHCAAAA',48,12.670000,52.160000,4.180000 |
| 'AAAAAAAAABHDAAAA',55,17.780000,0.000000,5.515000 |
| 'AAAAAAAAABJAAAAA',32,20.110000,0.000000,15.680000 |
| 'AAAAAAAAABJBAAAA',21,72.335000,0.000000,11.370000 |
| 'AAAAAAAAABJDAAAA',43,74.920000,0.000000,8.240000 |
| 'AAAAAAAAABKAAAAA',67,103.070000,0.000000,34.010000 |
| 'AAAAAAAAABKCAAAA',43,73.930000,0.000000,48.050000 |
| 'AAAAAAAAABKDAAAA',84,102.950000,0.000000,42.200000 |
| 'AAAAAAAAABMAAAAA',58,136.340000,0.000000,35.440000 |
| 'AAAAAAAAABMDAAAA',80,3.060000,0.000000,1.890000 |
| 'AAAAAAAAABNAAAAA',96,81.950000,0.000000,64.740000 |
| 'AAAAAAAAABNCAAAA',42,88.830000,0.000000,20.650000 |
| 'AAAAAAAAABOBAAAA',18,81.490000,0.000000,58.670000 |
| 'AAAAAAAAABOCAAAA',31,73.876667,0.000000,59.940000 |
| 'AAAAAAAAABPBAAAA',48.5,37.830000,183.780000,11.720000 |
| 'AAAAAAAAACACAAAA',60,104.375000,351.565000,25.315000 |
| 'AAAAAAAAACADAAAA',29,43.740000,0.000000,13.990000 |
| 'AAAAAAAAACBBAAAA',44.5,87.510000,0.000000,36.140000 |
| 'AAAAAAAAACBEAAAA',76,156.050000,0.000000,113.910000 |
| 'AAAAAAAAACCDAAAA',26,35.573333,0.000000,13.013333 |
| 'AAAAAAAAACCEAAAA',4,10.980000,0.000000,4.940000 |
| 'AAAAAAAAACDAAAAA',16,87.870000,36.260000,75.560000 |
| 'AAAAAAAAACDCAAAA',27,89.860000,0.000000,40.430000 |
| 'AAAAAAAAACEBAAAA',42,94.580000,0.000000,51.260000 |
| 'AAAAAAAAACFBAAAA',45,88.305000,0.000000,24.260000 |
| 'AAAAAAAAACGAAAAA',47,10.460000,0.000000,5.640000 |
| 'AAAAAAAAACGDAAAA',24,51.545000,0.000000,18.835000 |
| 'AAAAAAAAACHBAAAA',44,103.270000,0.000000,65.060000 |
| 'AAAAAAAAACHCAAAA',68.5,91.680000,0.000000,66.165000 |
| 'AAAAAAAAACIAAAAA',7,25.420000,0.000000,8.640000 |
| 'AAAAAAAAACIBAAAA',21,89.290000,915.010000,71.430000 |
| 'AAAAAAAAACIDAAAA',43,56.280000,56.110000,4.500000 |
| 'AAAAAAAAACLAAAAA',36,125.570000,0.000000,13.810000 |
| 'AAAAAAAAACLDAAAA',61.33333333333334,114.206667,0.000000,59.123333 |
| 'AAAAAAAAACMDAAAA',56,79.020000,0.000000,64.000000 |
| 'AAAAAAAAACNCAAAA',63,54.200000,0.000000,29.260000 |
| 'AAAAAAAAACOAAAAA',50,27.430000,229.215000,13.430000 |
| 'AAAAAAAAACPAAAAA',32,147.620000,2480.320000,87.090000 |
| 'AAAAAAAAACPCAAAA',80,12.600000,0.000000,0.370000 |
| 'AAAAAAAAACPDAAAA',87,105.930000,0.000000,9.530000 |
| 'AAAAAAAAADABAAAA',68.5,35.795000,0.000000,27.840000 |
| 'AAAAAAAAADACAAAA',96,101.540000,0.000000,99.500000 |
| 'AAAAAAAAADAEAAAA',53,74.640000,0.000000,7.630000 |
| 'AAAAAAAAADBBAAAA',6,85.580000,234.140000,81.300000 |
| 'AAAAAAAAADBDAAAA',47,39.330000,62.710000,12.090000 |
| 'AAAAAAAAADBEAAAA',52,2.410000,0.000000,1.060000 |
| 'AAAAAAAAADCAAAAA',91,92.170000,0.000000,67.280000 |
| 'AAAAAAAAADCCAAAA',33,40.800000,0.000000,28.560000 |
| 'AAAAAAAAADDBAAAA',45,18.630000,0.000000,17.690000 |
| 'AAAAAAAAADDCAAAA',66,162.170000,1525.900000,37.290000 |
| 'AAAAAAAAADDEAAAA',35,78.256667,0.000000,36.630000 |
| 'AAAAAAAAADEBAAAA',59.5,110.380000,157.965000,16.165000 |
| 'AAAAAAAAADEEAAAA',17,54.540000,0.000000,16.360000 |
| 'AAAAAAAAADFAAAAA',44,133.510000,0.000000,25.360000 |
| 'AAAAAAAAADGBAAAA',31,107.550000,919.825000,56.535000 |
| 'AAAAAAAAADGCAAAA',78,119.610000,0.000000,74.150000 |
| 'AAAAAAAAADGEAAAA',45.5,99.305000,0.000000,1.065000 |
| 'AAAAAAAAADHAAAAA',86,81.090000,0.000000,37.300000 |
| 'AAAAAAAAADHBAAAA',28,68.580000,223.790000,53.615000 |
| ---- TYPES |
| STRING, DOUBLE, DECIMAL, DECIMAL, DECIMAL |
| ==== |