ceph/src/s3select/TPCDS/sample-queries-tpcds/query15.sql

   1 -- start query 1 in stream 0 using template query15.tpl and seed 1819994127
   2 select  ca_zip
   3        ,sum(cs_sales_price)
   4  from catalog_sales
   5      ,customer
   6      ,customer_address
   7      ,date_dim
   8  where cs_bill_customer_sk = c_customer_sk
   9         and c_current_addr_sk = ca_address_sk
  10         and ( substr(ca_zip,1,5) in ('85669', '86197','88274','83405','86475',
  11                                    '85392', '85460', '80348', '81792')
  12               or ca_state in ('CA','WA','GA')
  13               or cs_sales_price > 500)
  14         and cs_sold_date_sk = d_date_sk
  15         and d_qoy = 2 and d_year = 1998
  16  group by ca_zip
  17  order by ca_zip
  18  limit 100;
  19
  20 -- end query 1 in stream 0 using template query15.tpl