| ==== |
| ---- QUERY: TPCDS-Q19 |
| select |
| i_brand_id brand_id, |
| i_brand brand, |
| i_manufact_id, |
| i_manufact, |
| sum(ss_ext_sales_price) ext_price |
| from |
| date_dim, |
| store_sales, |
| item, |
| customer, |
| customer_address, |
| store |
| where |
| d_date_sk = ss_sold_date_sk |
| and ss_item_sk = i_item_sk |
| and i_manager_id = 8 |
| and d_moy = 11 |
| and d_year = 1998 |
| and ss_customer_sk = c_customer_sk |
| and c_current_addr_sk = ca_address_sk |
| and substr(ca_zip, 1, 5) <> substr(s_zip, 1, 5) |
| and ss_store_sk = s_store_sk |
| group by |
| i_brand, |
| i_brand_id, |
| i_manufact_id, |
| i_manufact |
| order by |
| ext_price desc, |
| i_brand, |
| i_brand_id, |
| i_manufact_id, |
| i_manufact |
| limit 100; |
| ---- RESULTS |
| 3001001,'amalgexporti #1',358,'eingantipri',39779.20 |
| 5002002,'importoscholar #2',503,'pribaranti',38877.55 |
| 2002001,'importoimporto #1',229,'n stableable',38849.73 |
| 6009001,'maxicorp #1',609,'n stbarcally',37679.02 |
| 10012003,'importoamalgamalg #3',68,'eingcally',36856.35 |
| 10015008,'scholaramalgamalg #8',839,'n stprieing',36664.59 |
| 5003002,'exportischolar #2',50,'baranti',35402.74 |
| 4002002,'importoedu pack #2',615,'antioughtcally',34673.98 |
| 3002002,'importoexporti #2',581,'oughteinganti',34669.00 |
| 5002001,'importoscholar #1',442,'ableeseese',34618.53 |
| 5003001,'exportischolar #1',224,'eseableable',34541.38 |
| 5004002,'edu packscholar #2',168,'eingcallyought',33004.86 |
| 4001001,'amalgedu pack #1',379,'n stationpri',32777.45 |
| 7009009,'maxibrand #9',10,'barought',32448.47 |
| 8001009,'amalgnameless #9',21,'oughtable',32020.26 |
| 1003001,'exportiamalg #1',162,'ablecallyought',31531.85 |
| 10011013,'amalgamalgamalg #13',551,'oughtantianti',30259.44 |
| 9004003,'edu packmaxi #3',191,'oughtn stought',29977.55 |
| 7001002,'amalgbrand #2',122,'ableableought',29576.48 |
| 10013006,'exportiamalgamalg #6',461,'oughtcallyese',29475.71 |
| 7008009,'namelessbrand #9',540,'bareseanti',28888.95 |
| 7013001,'exportinameless #1',18,'eingought',28720.16 |
| 5004001,'edu packscholar #1',361,'oughtcallypri',28656.02 |
| 5003001,'exportischolar #1',457,'ationantiese',28560.52 |
| 5001001,'amalgscholar #1',192,'ablen stought',28136.83 |
| 8007009,'brandnameless #9',34,'esepri',27968.38 |
| 6010003,'univbrand #3',165,'anticallyought',27826.40 |
| 4003001,'exportiedu pack #1',30,'barpri',27681.74 |
| 1002002,'importoamalg #2',504,'esebaranti',27540.55 |
| 9009011,'maximaxi #11',117,'ationoughtought',26149.58 |
| 4002001,'importoedu pack #1',96,'callyn st',25291.42 |
| 10012006,'importoamalgamalg #6',162,'ablecallyought',25077.80 |
| 5002001,'importoscholar #1',202,'ablebarable',24662.36 |
| 5004002,'edu packscholar #2',427,'ationableese',24502.14 |
| 8009007,'maxinameless #7',146,'callyeseought',24020.70 |
| 7002005,'importobrand #5',822,'ableableeing',23637.35 |
| 4001001,'amalgedu pack #1',236,'callypriable',23425.22 |
| 3002001,'importoexporti #1',889,'n steingeing',23327.10 |
| 4001001,'amalgedu pack #1',106,'callybarought',23272.95 |
| 9004011,'edu packmaxi #11',241,'oughteseable',23233.46 |
| 3002002,'importoexporti #2',597,'ationn stanti',23181.94 |
| 6011005,'amalgbrand #5',373,'priationpri',22935.30 |
| 5004001,'edu packscholar #1',191,'oughtn stought',22767.49 |
| 10003001,'exportiunivamalg #1',252,'ableantiable',22605.56 |
| 2002001,'importoimporto #1',265,'anticallyable',22316.14 |
| 2004001,'edu packimporto #1',584,'eseeinganti',22312.87 |
| 4004002,'edu packedu pack #2',293,'prin stable',22272.04 |
| 9011008,'amalgunivamalg #8',93,'prin st',22103.70 |
| 1003002,'exportiamalg #2',400,'barbarese',21701.01 |
| 8006008,'corpnameless #8',605,'antibarcally',21599.44 |
| 7014001,'edu packnameless #1',23,'priable',21554.24 |
| 5001002,'amalgscholar #2',124,'eseableought',21004.37 |
| 5003002,'exportischolar #2',162,'ablecallyought',20986.26 |
| 3002001,'importoexporti #1',176,'callyationought',20741.06 |
| 2001001,'amalgimporto #1',219,'n stoughtable',20647.28 |
| 2002001,'importoimporto #1',100,'barbarought',20543.92 |
| 4004001,'edu packedu pack #1',718,'eingoughtation',20488.80 |
| 8014009,'edu packmaxi #9',214,'eseoughtable',20379.43 |
| 10010013,'univamalgamalg #13',656,'callyantically',20274.67 |
| 4003001,'exportiedu pack #1',640,'baresecally',20218.12 |
| 1001001,'amalgamalg #1',257,'ationantiable',19957.37 |
| 2002001,'importoimporto #1',525,'antiableanti',19888.38 |
| 8011002,'amalgmaxi #2',293,'prin stable',18991.25 |
| 4002001,'importoedu pack #1',101,'oughtbarought',18892.36 |
| 9012003,'importounivamalg #3',818,'eingoughteing',18832.74 |
| 10001014,'amalgunivamalg #14',207,'ationbarable',18623.57 |
| 4004001,'edu packedu pack #1',257,'ationantiable',18605.21 |
| 1004001,'edu packamalg #1',675,'antiationcally',18349.99 |
| 8012001,'importomaxi #1',277,'ationationable',18325.53 |
| 1004001,'edu packamalg #1',380,'bareingpri',17896.97 |
| 1002002,'importoamalg #2',50,'baranti',17737.23 |
| 1001001,'amalgamalg #1',346,'callyesepri',17660.98 |
| 2004002,'edu packimporto #2',912,'ableoughtn st',17422.31 |
| 6005006,'scholarcorp #6',270,'barationable',17373.47 |
| 8012007,'importomaxi #7',320,'barablepri',17247.22 |
| 1004001,'edu packamalg #1',594,'esen stanti',17217.04 |
| 10001009,'amalgunivamalg #9',414,'eseoughtese',17196.10 |
| 1003002,'exportiamalg #2',483,'prieingese',17180.13 |
| 10010005,'univamalgamalg #5',684,'eseeingcally',17146.97 |
| 6004005,'edu packcorp #5',224,'eseableable',17081.31 |
| 2002001,'importoimporto #1',134,'esepriought',16596.84 |
| 8014007,'edu packmaxi #7',350,'barantipri',16580.66 |
| 6007007,'brandcorp #7',47,'ationese',16413.40 |
| 10011002,'amalgamalgamalg #2',112,'ableoughtought',16120.65 |
| 2003001,'exportiimporto #1',288,'eingeingable',15769.87 |
| 1002002,'importoamalg #2',489,'n steingese',15707.42 |
| 6013003,'exportibrand #3',16,'callyought',15594.16 |
| 10008005,'namelessunivamalg #5',813,'prioughteing',15433.53 |
| 10004013,'edu packunivamalg #13',764,'esecallyation',15242.69 |
| 9016003,'corpunivamalg #3',51,'oughtanti',15172.76 |
| 10006012,'corpunivamalg #12',166,'callycallyought',15153.42 |
| 5004001,'edu packscholar #1',595,'antin stanti',14910.27 |
| 8003003,'exportinameless #3',85,'antieing',14890.03 |
| 4003001,'exportiedu pack #1',239,'n stpriable',14778.52 |
| 6006001,'corpcorp #1',258,'eingantiable',14579.72 |
| 1004001,'edu packamalg #1',222,'ableableable',14254.25 |
| 4003002,'exportiedu pack #2',117,'ationoughtought',14161.18 |
| 1001001,'amalgamalg #1',89,'n steing',14133.10 |
| 8016009,'corpmaxi #9',734,'esepriation',14055.01 |
| 1002001,'importoamalg #1',184,'eseeingought',13719.81 |
| ---- TYPES |
| INT, STRING, INT, STRING, DECIMAL |
| ==== |