testdata/workloads/tpcds/queries/tpcds-q3.test

====
---- QUERY: TPCDS-Q3
select
  dt.d_year,
  item.i_brand_id brand_id,
  item.i_brand brand,
  sum(ss_ext_sales_price) sum_agg
from
  date_dim dt,
  store_sales ss,
  item
where
  dt.d_date_sk = ss.ss_sold_date_sk
  and ss.ss_item_sk = item.i_item_sk
  and item.i_manufact_id = 128
  and dt.d_moy = 11
group by
  dt.d_year,
  item.i_brand,
  item.i_brand_id
order by
  dt.d_year,
  sum_agg desc,
  brand_id
limit 100;
---- RESULTS
1998,2001001,'amalgimporto #1',45162.45
1998,5003001,'exportischolar #1',40600.56
1998,5001001,'amalgscholar #1',32515.11
1998,3004001,'edu packexporti #1',32443.16
1998,3001001,'amalgexporti #1',30280.72
1998,3001002,'amalgexporti #2',27644.68
1998,1003001,'exportiamalg #1',25408.10
1998,7007010,'brandbrand #10',23346.45
1998,8001009,'amalgnameless #9',20792.57
1998,10010002,'univamalgamalg #2',20398.90
1998,7009008,'maxibrand #8',19199.75
1998,6004008,'edu packcorp #8',18022.24
1998,1004001,'edu packamalg #1',17434.09
1998,10001002,'amalgunivamalg #2',15434.73
1998,5004001,'edu packscholar #1',15184.40
1998,7003009,'exportibrand #9',11669.32
1998,1001002,'amalgamalg #2',10725.87
1998,5003002,'exportischolar #2',10250.29
1999,7003009,'exportibrand #9',60081.08
1999,3004001,'edu packexporti #1',57285.04
1999,2001001,'amalgimporto #1',46294.06
1999,5004001,'edu packscholar #1',29587.74
1999,1003001,'exportiamalg #1',28354.52
1999,10001002,'amalgunivamalg #2',25166.82
1999,5003001,'exportischolar #1',20350.80
1999,1001002,'amalgamalg #2',18476.51
1999,5003002,'exportischolar #2',17769.35
1999,7009008,'maxibrand #8',16413.03
1999,1004001,'edu packamalg #1',14950.65
1999,6004008,'edu packcorp #8',14524.78
1999,3001001,'amalgexporti #1',13895.01
1999,5001001,'amalgscholar #1',11468.36
1999,7007010,'brandbrand #10',10103.81
1999,10010002,'univamalgamalg #2',7640.55
1999,8001009,'amalgnameless #9',7324.50
1999,3001002,'amalgexporti #2',2940.88
2000,1003001,'exportiamalg #1',35841.00
2000,2001001,'amalgimporto #1',32500.27
2000,3001002,'amalgexporti #2',32059.56
2000,3004001,'edu packexporti #1',29891.01
2000,1001002,'amalgamalg #2',19888.62
2000,10001002,'amalgunivamalg #2',19325.34
2000,3001001,'amalgexporti #1',19261.58
2000,10008017,'namelessunivamalg #17',17207.60
2000,5003002,'exportischolar #2',16365.82
2000,5003001,'amalgunivamalg #2',15140.30
2000,1004001,'edu packamalg #1',15074.32
2000,7009008,'maxibrand #8',15042.42
2000,5004001,'edu packscholar #1',14744.21
2000,6004008,'edu packcorp #8',13303.65
2000,7007010,'brandbrand #10',12915.75
2000,7003009,'exportibrand #9',11347.80
2000,8001009,'importoexporti #2',10520.76
2001,1001002,'amalgamalg #2',40840.34
2001,1004001,'exportiexporti #2',27499.42
2001,10008017,'namelessunivamalg #17',25766.09
2001,4001001,'scholaramalgamalg #15',23917.98
2001,7007010,'brandbrand #10',23807.16
2001,1003001,'exportiamalg #2',21192.81
2001,6004008,'edu packcorp #8',20966.17
2001,5003002,'exportischolar #2',20410.45
2001,8001009,'importoexporti #2',19273.11
2001,3001002,'amalgexporti #2',18047.23
2001,6005001,'edu packimporto #2',16801.34
2001,2001001,'exportischolar #2',15894.57
2001,5003001,'amalgunivamalg #2',15883.30
2001,7011010,'amalgnameless #10',15174.18
2001,5004001,'edu packunivamalg #8',10452.64
2001,8004010,'edu packnameless #10',8565.95
2001,3001001,'importoscholar #2',7765.96
2001,7009008,'maxibrand #8',3570.11
2002,1001002,'amalgamalg #2',57204.62
2002,6004008,'edu packcorp #8',39584.99
2002,8004010,'edu packnameless #10',30357.37
2002,3001002,'amalgexporti #2',23025.23
2002,3001001,'importoscholar #2',21157.23
2002,1003001,'exportiamalg #2',20535.46
2002,7007010,'brandbrand #10',19387.78
2002,7009008,'maxibrand #8',17673.93
2002,5004001,'edu packunivamalg #8',15175.94
2002,4001001,'scholaramalgamalg #15',14984.83
2002,6005001,'edu packimporto #2',14774.23
2002,1004001,'exportiexporti #2',13016.75
2002,7011010,'amalgnameless #10',12343.97
2002,10008017,'amalgedu pack #1',10334.40
2002,10013016,'exportiamalgamalg #16',8356.19
2002,5003002,'exportischolar #2',5435.81
2002,2001001,'exportischolar #2',4162.39
2002,5001001,'amalgscholar #1',3537.49
---- TYPES
INT, INT, STRING, DECIMAL
====