| -- SQLBench-DS query 15 derived from TPC-DS query 15 under the terms of the TPC Fair Use Policy. |
| -- TPC-DS queries are Copyright 2021 Transaction Processing Performance Council. |
| -- This query was generated at scale factor 1. |
| 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 = 2002 |
| group by ca_zip |
| order by ca_zip |
| LIMIT 100; |
| |
