| ==== |
| ---- QUERY: TPCDS-Q45 |
| SELECT ca_zip, |
| ca_city, |
| sum(ws_sales_price) |
| FROM web_sales, |
| customer, |
| customer_address, |
| date_dim, |
| item |
| WHERE ws_bill_customer_sk = c_customer_sk |
| AND c_current_addr_sk = ca_address_sk |
| AND ws_item_sk = i_item_sk |
| AND (SUBSTRING(ca_zip,1,5) IN ('85669', |
| '86197', |
| '88274', |
| '83405', |
| '86475', |
| '85392', |
| '85460', |
| '80348', |
| '81792') |
| OR i_item_id IN |
| (SELECT i_item_id |
| FROM item |
| WHERE i_item_sk IN (2, |
| 3, |
| 5, |
| 7, |
| 11, |
| 13, |
| 17, |
| 19, |
| 23, |
| 29) )) |
| AND ws_sold_date_sk = d_date_sk |
| AND d_qoy = 2 |
| AND d_year = 2001 |
| GROUP BY ca_zip, |
| ca_city |
| ORDER BY ca_zip, |
| ca_city |
| LIMIT 100; |
| ---- RESULTS |
| '10150','Bunker Hill',20.25 |
| '16098','Five Points',18.05 |
| '28048','Salem',9.81 |
| '29584','Oakdale',41.21 |
| '31289','Lincoln',1.26 |
| '34975','Kingston',56.67 |
| '36971','Wilson',202.63 |
| '38354','Sulphur Springs',25.68 |
| '44975','Kingston',12.62 |
| '62808','Hamilton',85.39 |
| '62812','Shady Grove',48.77 |
| '66557','Arlington',2.68 |
| '68252','Maple Grove',11.37 |
| '69583','Jackson',54.42 |
| '73003','Hillcrest',36.03 |
| '78222','Clinton',85.87 |
| '83683','Plainview',43.82 |
| '84536','Friendship',64.44 |
| '88370','Oak Grove',52.42 |
| ---- TYPES |
| STRING, STRING, DECIMAL |
| ==== |