text: alter session set query_tag='corp_job query10';
  use role CORP_BIZ_USER; 
  use database CORP_DATA; 
  use schema CORP_SCHEMA; 
  use warehouse DATAGOV;
  
  select  
    cd_gender,
    cd_marital_status,
    cd_education_status,
    count(*) cnt1,
    cd_purchase_estimate,
    count(*) cnt2,
    cd_credit_rating,
    count(*) cnt3,
    cd_dep_count,
    count(*) cnt4,
    cd_dep_employed_count,
    count(*) cnt5,
    cd_dep_college_count,
    count(*) cnt6
   from
    CORP_DATA.CORP_SCHEMA.CUSTOMER c,
    CORP_DATA.CORP_SCHEMA.CUSTOMER_ADDRESS ca,
    CORP_DATA.CORP_SCHEMA.CUSTOMER_DEMOGRAPHICS_FIN
   where
    c.c_current_addr_sk = ca.ca_address_sk and
    ca_county in ('Walker County','Richland County','Gaines County','Douglas County','Dona Ana County') and
    cd_demo_sk = c.c_current_cdemo_sk and 
    exists (select *
            from CORP_DATA.CORP_SCHEMA.STORE_SALES_RET,CORP_DATA.CORP_SCHEMA.DATE_DIM
            where c.c_customer_sk = ss_customer_sk and
                  ss_sold_date_sk = d_date_sk and
                  d_year = 2002 and
                  d_moy between 4 and 4+3) and
     (exists (select *
              from CORP_DATA.CORP_SCHEMA.WEB_SALES_RET,CORP_DATA.CORP_SCHEMA.DATE_DIM
              where c.c_customer_sk = ws_bill_customer_sk and
                    ws_sold_date_sk = d_date_sk and
                    d_year = 2002 and
                    d_moy between 4 ANd 4+3) or 
      exists (select * 
              from CORP_DATA.CORP_SCHEMA.CATALOG_SALES_RET,CORP_DATA.CORP_SCHEMA.DATE_DIM
              where c.c_customer_sk = cs_ship_customer_sk and
                    cs_sold_date_sk = d_date_sk and
                    d_year = 2002 and
                    d_moy between 4 and 4+3))
   group by cd_gender,
            cd_marital_status,
            cd_education_status,
            cd_purchase_estimate,
            cd_credit_rating,
            cd_dep_count,
            cd_dep_employed_count,
            cd_dep_college_count
   order by cd_gender,
            cd_marital_status,
            cd_education_status,
            cd_purchase_estimate,
            cd_credit_rating,
            cd_dep_count,
            cd_dep_employed_count,
            cd_dep_college_count
  limit 100;
  