mirror of
https://github.com/hanzoai/datastore.git
synced 2026-09-26 13:55:07 +00:00
17 lines
510 B
SQL
17 lines
510 B
SQL
SELECT
|
|
ca_zip,
|
|
sum(cs_sales_price)
|
|
FROM catalog_sales, customer, customer_address, date_dim
|
|
WHERE (cs_bill_customer_sk = c_customer_sk)
|
|
AND (c_current_addr_sk = ca_address_sk)
|
|
AND ((substr(ca_zip, 1, 5) IN ('85669', '86197', '88274', '83405', '86475', '85392', '85460', '80348', '81792'))
|
|
OR (ca_state IN ('CA', 'WA', 'GA'))
|
|
OR (cs_sales_price > 500))
|
|
AND (cs_sold_date_sk = d_date_sk)
|
|
AND (d_qoy = 2)
|
|
AND (d_year = 2001)
|
|
GROUP BY ca_zip
|
|
ORDER BY ca_zip
|
|
LIMIT 100;
|
|
|