====
---- 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.15,7.70,1.97
'AAAAAAAAAAAEAAAA',99,123.44,0.00,44.43
'AAAAAAAAAABBAAAA',11,77.31,0.00,38.65
'AAAAAAAAAABEAAAA',35.5,18.90,0.00,4.85
'AAAAAAAAAACAAAAA',61,38.63,90.24,16.38
'AAAAAAAAAACCAAAA',10.5,83.46,0.00,30.02
'AAAAAAAAAADBAAAA',44,108.36,0.00,13.00
'AAAAAAAAAADCAAAA',54,59.29,0.00,34.98
'AAAAAAAAAADEAAAA',93,43.57,0.00,38.34
'AAAAAAAAAAEAAAAA',72,16.46,0.00,13.33
'AAAAAAAAAAEBAAAA',88,29.02,0.00,0.87
'AAAAAAAAAAEDAAAA',91,84.37,0.00,9.09
'AAAAAAAAAAFDAAAA',37,33.13,0.00,20.20
'AAAAAAAAAAGEAAAA',35,56.48,881.45,23.63
'AAAAAAAAAAHDAAAA',33,59.05,0.00,48.53
'AAAAAAAAAAICAAAA',68.5,108.73,166.78,69.22
'AAAAAAAAAAIDAAAA',76,97.19,0.00,43.73
'AAAAAAAAAAJCAAAA',30,47.55,0.00,30.43
'AAAAAAAAAAKBAAAA',59,55.08,0.00,17.07
'AAAAAAAAAAMBAAAA',74,10.39,0.00,8.62
'AAAAAAAAAAMCAAAA',86,24.10,0.41,0.48
'AAAAAAAAAANAAAAA',43,80.16,0.00,41.68
'AAAAAAAAAANBAAAA',28,112.27,0.00,57.25
'AAAAAAAAAAOAAAAA',46,12.63,0.00,4.67
'AAAAAAAAAAPBAAAA',66,39.59,969.80,18.60
'AAAAAAAAAAPCAAAA',90,68.28,0.00,47.79
'AAAAAAAAABAAAAAA',10.5,71.48,0.00,28.92
'AAAAAAAAABABAAAA',12.5,100.53,2.23,34.80
'AAAAAAAAABADAAAA',100,68.67,0.00,50.81
'AAAAAAAAABAEAAAA',49,15.79,0.00,11.84
'AAAAAAAAABBCAAAA',52,115.10,0.00,24.17
'AAAAAAAAABDEAAAA',92,168.96,0.00,23.65
'AAAAAAAAABEAAAAA',33.33333333333334,58.64,99.47,22.16
'AAAAAAAAABECAAAA',43,167.74,0.00,88.90
'AAAAAAAAABEDAAAA',74,129.10,0.00,108.44
'AAAAAAAAABFBAAAA',36,115.18,0.00,109.42
'AAAAAAAAABFCAAAA',51,121.98,0.00,17.07
'AAAAAAAAABFEAAAA',65,117.88,0.00,107.27
'AAAAAAAAABGBAAAA',52,71.54,0.00,30.28
'AAAAAAAAABGDAAAA',67.5,58.86,0.00,35.25
'AAAAAAAAABHAAAAA',71,39.38,804.37,8.38
'AAAAAAAAABHCAAAA',48,12.67,52.16,4.18
'AAAAAAAAABHDAAAA',55,17.78,0.00,5.51
'AAAAAAAAABJAAAAA',32,20.11,0.00,15.68
'AAAAAAAAABJBAAAA',21,72.33,0.00,11.37
'AAAAAAAAABJDAAAA',43,74.92,0.00,8.24
'AAAAAAAAABKAAAAA',67,103.07,0.00,34.01
'AAAAAAAAABKCAAAA',43,73.93,0.00,48.05
'AAAAAAAAABKDAAAA',84,102.95,0.00,42.20
'AAAAAAAAABMAAAAA',58,136.34,0.00,35.44
'AAAAAAAAABMDAAAA',80,3.06,0.00,1.89
'AAAAAAAAABNAAAAA',96,81.95,0.00,64.74
'AAAAAAAAABNCAAAA',42,88.83,0.00,20.65
'AAAAAAAAABOBAAAA',18,81.49,0.00,58.67
'AAAAAAAAABOCAAAA',31,73.87,0.00,59.94
'AAAAAAAAABPBAAAA',48.5,37.83,183.78,11.72
'AAAAAAAAACACAAAA',60,104.37,351.56,25.31
'AAAAAAAAACADAAAA',29,43.74,0.00,13.99
'AAAAAAAAACBBAAAA',44.5,87.51,0.00,36.14
'AAAAAAAAACBEAAAA',76,156.05,0.00,113.91
'AAAAAAAAACCDAAAA',26,35.57,0.00,13.01
'AAAAAAAAACCEAAAA',4,10.98,0.00,4.94
'AAAAAAAAACDAAAAA',16,87.87,36.26,75.56
'AAAAAAAAACDCAAAA',27,89.86,0.00,40.43
'AAAAAAAAACEBAAAA',42,94.58,0.00,51.26
'AAAAAAAAACFBAAAA',45,88.30,0.00,24.26
'AAAAAAAAACGAAAAA',47,10.46,0.00,5.64
'AAAAAAAAACGDAAAA',24,51.54,0.00,18.83
'AAAAAAAAACHBAAAA',44,103.27,0.00,65.06
'AAAAAAAAACHCAAAA',68.5,91.68,0.00,66.16
'AAAAAAAAACIAAAAA',7,25.42,0.00,8.64
'AAAAAAAAACIBAAAA',21,89.29,915.01,71.43
'AAAAAAAAACIDAAAA',43,56.28,56.11,4.50
'AAAAAAAAACLAAAAA',36,125.57,0.00,13.81
'AAAAAAAAACLDAAAA',61.33333333333334,114.20,0.00,59.12
'AAAAAAAAACMDAAAA',56,79.02,0.00,64.00
'AAAAAAAAACNCAAAA',63,54.20,0.00,29.26
'AAAAAAAAACOAAAAA',50,27.43,229.21,13.43
'AAAAAAAAACPAAAAA',32,147.62,2480.32,87.09
'AAAAAAAAACPCAAAA',80,12.60,0.00,0.37
'AAAAAAAAACPDAAAA',87,105.93,0.00,9.53
'AAAAAAAAADABAAAA',68.5,35.79,0.00,27.84
'AAAAAAAAADACAAAA',96,101.54,0.00,99.50
'AAAAAAAAADAEAAAA',53,74.64,0.00,7.63
'AAAAAAAAADBBAAAA',6,85.58,234.14,81.30
'AAAAAAAAADBDAAAA',47,39.33,62.71,12.09
'AAAAAAAAADBEAAAA',52,2.41,0.00,1.06
'AAAAAAAAADCAAAAA',91,92.17,0.00,67.28
'AAAAAAAAADCCAAAA',33,40.80,0.00,28.56
'AAAAAAAAADDBAAAA',45,18.63,0.00,17.69
'AAAAAAAAADDCAAAA',66,162.17,1525.90,37.29
'AAAAAAAAADDEAAAA',35,78.25,0.00,36.63
'AAAAAAAAADEBAAAA',59.5,110.38,157.96,16.16
'AAAAAAAAADEEAAAA',17,54.54,0.00,16.36
'AAAAAAAAADFAAAAA',44,133.51,0.00,25.36
'AAAAAAAAADGBAAAA',31,107.55,919.82,56.53
'AAAAAAAAADGCAAAA',78,119.61,0.00,74.15
'AAAAAAAAADGEAAAA',45.5,99.30,0.00,1.06
'AAAAAAAAADHAAAAA',86,81.09,0.00,37.30
'AAAAAAAAADHBAAAA',28,68.58,223.79,53.61
---- TYPES
STRING, DOUBLE, DECIMAL, DECIMAL, DECIMAL
====