====
---- QUERY: TPCDS-Q52
select
  dt.d_year,
  item.i_brand_id brand_id,
  item.i_brand brand,
  sum(ss_ext_sales_price) ext_price
from
  date_dim dt,
  store_sales,
  item
where
  dt.d_date_sk = store_sales.ss_sold_date_sk
  and store_sales.ss_item_sk = item.i_item_sk
  and item.i_manager_id = 1
  and dt.d_moy = 11
  and dt.d_year = 2000
group by
  dt.d_year,
  item.i_brand,
  item.i_brand_id
order by
  dt.d_year,
  ext_price desc,
  brand_id
limit 100;
---- RESULTS
2000,2001002,'amalgimporto #2',133668.20
2000,1003001,'exportiamalg #1',85038.62
2000,3002002,'importoexporti #2',79104.47
2000,3004002,'edu packexporti #2',78772.08
2000,3003001,'exportiexporti #1',67105.01
2000,2004002,'edu packimporto #2',65904.27
2000,4001002,'amalgedu pack #2',56283.13
2000,5002002,'importoscholar #2',54390.12
2000,7016001,'corpnameless #1',51331.65
2000,2002001,'importoimporto #1',50831.66
2000,7001005,'amalgbrand #5',50727.31
2000,9015009,'scholarunivamalg #9',49522.53
2000,5004002,'edu packscholar #2',45205.15
2000,4003001,'exportiedu pack #1',42810.52
2000,5001002,'amalgscholar #2',42061.33
2000,1003002,'exportiamalg #2',41130.32
2000,2003002,'exportiimporto #2',39318.67
2000,7007004,'brandbrand #4',38993.74
2000,1002002,'importoamalg #2',38952.02
2000,8003010,'exportinameless #10',37010.51
2000,1002001,'importounivamalg #1',36393.47
2000,4002001,'scholarmaxi #6',34103.67
2000,1001002,'amalgamalg #2',32518.42
2000,4004002,'edu packedu pack #2',32114.76
2000,5001001,'edu packexporti #2',31507.22
2000,6005005,'edu packnameless #8',31445.28
2000,1001001,'amalgamalg #1',31305.49
2000,4002001,'importoedu pack #1',31248.26
2000,6005001,'scholarcorp #1',30955.09
2000,1004001,'edu packamalg #1',30464.10
2000,7009004,'maxibrand #4',29127.01
2000,10010013,'univamalgamalg #13',29071.87
2000,6012008,'importobrand #8',28799.91
2000,8005009,'corpnameless #10',28231.03
2000,5003001,'exportischolar #1',27336.64
2000,5001001,'brandunivamalg #11',26418.90
2000,3001002,'amalgexporti #2',25858.35
2000,4004001,'edu packedu pack #1',25715.17
2000,7009009,'exportibrand #10',25380.68
2000,4004001,'maxinameless #8',23992.40
2000,10014001,'maxibrand #4',23662.09
2000,10009015,'maxiunivamalg #15',23576.97
2000,3003001,'exportiedu pack #2',21959.63
2000,10004004,'edu packunivamalg #4',21950.07
2000,3002001,'importoexporti #1',21677.43
2000,1004002,'edu packamalg #2',21563.27
2000,2002002,'importoimporto #2',21502.53
2000,2001001,'importoimporto #2',21106.22
2000,9012003,'importounivamalg #3',21075.27
2000,3003002,'exportiexporti #2',20711.54
2000,10015013,'scholaramalgamalg #13',20610.41
2000,7010005,'corpunivamalg #6',19821.13
2000,4003001,'exportischolar #2',19693.88
2000,9012008,'importounivamalg #8',19463.65
2000,7010009,'univnameless #9',19176.91
2000,7008004,'namelessbrand #4',19128.07
2000,2003001,'exportiimporto #1',19074.52
2000,6008005,'namelesscorp #5',19067.51
2000,3004001,'edu packexporti #1',18504.78
2000,5001001,'exportinameless #8',18493.00
2000,10003016,'exportiunivamalg #16',18413.97
2000,3001001,'maxibrand #8',18290.52
2000,8003007,'edu packnameless #8',18265.99
2000,7016007,'corpnameless #7',18103.37
2000,5003002,'exportischolar #2',17930.96
2000,8016004,'corpmaxi #4',17828.86
2000,2004001,'importoexporti #2',17646.57
2000,10004012,'edu packunivamalg #12',17608.05
2000,8002009,'importonameless #9',17513.05
2000,7004009,'importoimporto #2',17312.88
2000,2004001,'edu packunivamalg #8',17084.17
2000,9014006,'edu packunivamalg #6',16958.88
2000,9015011,'exportiamalg #2',15875.77
2000,10004005,'importounivamalg #6',15258.42
2000,6008002,'namelesscorp #2',15199.06
2000,6004002,'edu packcorp #2',14905.77
2000,9013009,'exportiunivamalg #9',14704.96
2000,7012010,'importonameless #10',14697.15
2000,7013007,'exportinameless #7',14068.62
2000,7008009,'namelessbrand #9',13759.65
2000,7006007,'edu packamalg #2',13705.14
2000,10012004,'importoamalgamalg #4',13514.95
2000,6015006,'scholarbrand #6',13421.39
2000,10002012,'importounivamalg #12',13080.55
2000,9016003,'corpunivamalg #3',12936.25
2000,6002004,'importocorp #4',12491.48
2000,8004003,'edu packnameless #3',12480.24
2000,6011008,'amalgbrand #8',12236.00
2000,6003008,'exporticorp #8',11621.79
2000,8005008,'scholarnameless #8',11609.84
2000,4001001,'amalgedu pack #1',11110.78
2000,7009010,'maxibrand #10',11061.00
2000,3004001,'edu packscholar #2',11025.47
2000,7012001,'amalgamalgamalg #2',10846.24
2000,7016009,'univnameless #10',10454.42
2000,7014001,'edu packnameless #1',9596.47
2000,1002001,'importoamalg #1',9579.28
2000,8010004,'univmaxi #4',9508.89
2000,3001001,'amalgexporti #1',9373.84
2000,6010005,'univbrand #5',9222.91
---- TYPES
INT, INT, STRING, DECIMAL
====