====
---- 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
====