====
---- QUERY: TPCDS-Q55
select
  i_brand_id brand_id,
  i_brand brand,
  sum(ss_ext_sales_price) ext_price
from
  date_dim,
  store_sales,
  item
where
  d_date_sk = ss_sold_date_sk
  and ss_item_sk = i_item_sk
  and i_manager_id = 28
  and d_moy = 12
  and d_year = 1999
group by
  i_brand,
  i_brand_id
order by
  ext_price desc,
  i_brand_id
limit 100;
---- RESULTS
1001001,'amalgamalg #1',136722.83
2001001,'amalgimporto #1',133391.08
5001001,'amalgscholar #1',118347.84
5003001,'exportischolar #1',109595.01
1002001,'importoamalg #1',105226.72
5003002,'exportischolar #2',95810.25
5004001,'edu packscholar #1',90624.90
4001001,'amalgedu pack #1',83730.42
1001002,'amalgamalg #2',81937.80
4001002,'amalgedu pack #2',78799.33
2002001,'importoimporto #1',77701.54
3003001,'exportiexporti #1',66809.69
4002001,'importoedu pack #1',65056.38
5001002,'amalgscholar #2',63100.23
4003001,'exportiedu pack #1',61067.16
3001001,'amalgexporti #1',58157.56
5002001,'importoscholar #1',57895.73
2003001,'exportiimporto #1',54996.70
4004002,'edu packedu pack #2',54650.86
6016005,'corpbrand #5',50955.77
1004001,'edu packamalg #1',50844.36
6002001,'importocorp #1',48122.46
7015003,'scholarnameless #3',47531.49
1004002,'edu packamalg #2',46925.04
6006006,'corpcorp #6',44504.94
3002001,'importoexporti #1',44449.84
5002002,'importoscholar #2',43736.13
9004008,'edu packmaxi #8',43124.13
6011006,'amalgbrand #6',42516.13
9016003,'corpunivamalg #3',41651.94
8009007,'maxinameless #7',40216.48
9008008,'namelessmaxi #8',37294.08
10012012,'importoamalgamalg #12',36166.35
2004001,'edu packimporto #1',36056.65
10003013,'exportiunivamalg #13',32619.62
1003001,'exportiamalg #1',28084.23
8010006,'univmaxi #6',27531.46
8006005,'corpnameless #5',26468.77
2004002,'edu packimporto #2',26438.94
6014007,'edu packbrand #7',25884.76
6005001,'scholarcorp #1',25849.68
9005002,'scholarmaxi #2',25116.15
9011003,'amalgunivamalg #3',25085.52
10006017,'corpunivamalg #17',25085.08
6009008,'maxicorp #8',24934.96
7011009,'amalgnameless #9',24823.19
9011009,'amalgunivamalg #9',24802.03
8013007,'exportimaxi #7',24582.70
8012005,'importomaxi #5',24370.92
6003006,'exporticorp #6',23710.13
3004001,'edu packexporti #1',23358.51
1003002,'exportiamalg #2',23154.78
7002004,'importobrand #4',23003.13
9005011,'scholarmaxi #11',22313.86
9013009,'exportiunivamalg #9',22303.83
9003003,'exportimaxi #3',21736.62
2001002,'amalgimporto #2',21466.13
6011001,'amalgbrand #1',21162.91
6008008,'namelesscorp #8',20636.40
9016009,'corpunivamalg #9',20465.89
10013009,'exportiamalgamalg #9',19610.85
10009006,'maxiunivamalg #6',19564.84
4002002,'importoedu pack #2',19399.39
3002002,'importoexporti #2',19272.70
6002002,'importocorp #2',19147.26
3001002,'amalgexporti #2',19008.57
6014001,'edu packbrand #1',18807.55
8002010,'importonameless #10',18591.58
7003005,'exportibrand #5',18527.36
2003002,'exportiimporto #2',18318.61
6005003,'scholarcorp #3',18167.51
8009003,'maxinameless #3',17115.53
8001003,'amalgnameless #3',17068.61
7015007,'scholarnameless #7',16069.97
9011008,'amalgunivamalg #8',15861.18
8011009,'amalgmaxi #9',15785.74
6014008,'edu packbrand #8',15668.28
10016003,'corpamalgamalg #3',15322.94
6015003,'scholarbrand #3',14890.37
8005010,'scholarnameless #10',14620.95
8004009,'edu packnameless #9',14529.33
10004001,'edu packunivamalg #1',14101.90
8006008,'corpnameless #8',13159.42
10015001,'scholaramalgamalg #1',13119.59
9015009,'scholarunivamalg #9',12679.95
7006010,'corpbrand #10',11490.56
10005001,'scholarunivamalg #1',11299.62
6015001,'scholarbrand #1',11242.40
6013007,'exportibrand #7',11162.36
6006002,'corpcorp #2',10986.40
10015011,'scholaramalgamalg #11',10980.10
8004003,'edu packnameless #3',10945.08
6001005,'amalgcorp #5',10108.20
10014016,'edu packamalgamalg #16',9656.21
6008001,'namelesscorp #1',9546.46
6009003,'maxicorp #3',8425.25
10011013,'amalgamalgamalg #13',7914.33
7009005,'maxibrand #5',7859.23
10006001,'corpunivamalg #1',6901.74
9009002,'maximaxi #2',4025.61
---- TYPES
INT, STRING, DECIMAL
====