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