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