text: --  Licensed to the Apache Software Foundation (ASF) under one or more
  --  contributor license agreements. See the NOTICE file distributed with
  --  this work for additional information regarding copyright ownership.
  --  The ASF licenses this file to You under the Apache License, Version 2.0
  --  (the "License"); you may not use this file except in compliance with
  --  the License. You may obtain a copy of the License at
  --
  --    http://www.apache.org/licenses/LICENSE-2.0
  --
  --  Unless required by applicable law or agreed to in writing, software
  --  distributed under the License is distributed on an "AS IS" BASIS,
  --  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  --  See the License for the specific language governing permissions and
  --  limitations under the License.
  
  SELECT
    cd_gender,
    cd_marital_status,
    cd_education_status,
    count(*) cnt1,
    cd_purchase_estimate,
    count(*) cnt2,
    cd_credit_rating,
    count(*) cnt3
  FROM
    customer c, customer_address ca, customer_demographics
  WHERE
    c.c_current_addr_sk = ca.ca_address_sk AND
      ca_state IN ('KY', 'GA', 'NM') AND
      cd_demo_sk = c.c_current_cdemo_sk AND
      exists(SELECT *
             FROM store_sales, date_dim
             WHERE c.c_customer_sk = ss_customer_sk AND
               ss_sold_date_sk = d_date_sk AND
               d_year = 2001 AND
               d_moy BETWEEN 4 AND 4 + 2) AND
      (NOT exists(SELECT *
                  FROM web_sales, date_dim
                  WHERE c.c_customer_sk = ws_bill_customer_sk AND
                    ws_sold_date_sk = d_date_sk AND
                    d_year = 2001 AND
                    d_moy BETWEEN 4 AND 4 + 2) AND
        NOT exists(SELECT *
                   FROM catalog_sales, date_dim
                   WHERE c.c_customer_sk = cs_ship_customer_sk AND
                     cs_sold_date_sk = d_date_sk AND
                     d_year = 2001 AND
                     d_moy BETWEEN 4 AND 4 + 2))
  GROUP BY cd_gender, cd_marital_status, cd_education_status,
    cd_purchase_estimate, cd_credit_rating
  ORDER BY cd_gender, cd_marital_status, cd_education_status,
    cd_purchase_estimate, cd_credit_rating
  LIMIT 100
  