0001 SELECT
0002 ca_zip,
0003 ca_city,
0004 sum(ws_sales_price)
0005 FROM web_sales, customer, customer_address, date_dim, item
0006 WHERE ws_bill_customer_sk = c_customer_sk
0007 AND c_current_addr_sk = ca_address_sk
0008 AND ws_item_sk = i_item_sk
0009 AND (substr(ca_zip, 1, 5) IN
0010 ('85669', '86197', '88274', '83405', '86475', '85392', '85460', '80348', '81792')
0011 OR
0012 i_item_id IN (SELECT i_item_id
0013 FROM item
0014 WHERE i_item_sk IN (2, 3, 5, 7, 11, 13, 17, 19, 23, 29)
0015 )
0016 )
0017 AND ws_sold_date_sk = d_date_sk
0018 AND d_qoy = 2 AND d_year = 2001
0019 GROUP BY ca_zip, ca_city
0020 ORDER BY ca_zip, ca_city
0021 LIMIT 100
