-- start query 80 in stream 0 using template query84.tpl
select  c_customer_id as customer_id
       , coalesce(c_last_name,'') || ', ' || coalesce(c_first_name,'') as customername
 from bigdata_public_dataset.tpcds_100t.customer
     ,bigdata_public_dataset.tpcds_100t.customer_address
     ,bigdata_public_dataset.tpcds_100t.customer_demographics
     ,bigdata_public_dataset.tpcds_100t.household_demographics
     ,bigdata_public_dataset.tpcds_100t.income_band
     ,bigdata_public_dataset.tpcds_100t.store_returns
 where ca_city	        =  'Deerfield'
   and c_current_addr_sk = ca_address_sk
   and ib_lower_bound   >=  55110
   and ib_upper_bound   <=  55110 + 50000
   and ib_income_band_sk = hd_income_band_sk
   and cd_demo_sk = c_current_cdemo_sk
   and hd_demo_sk = c_current_hdemo_sk
   and sr_cdemo_sk = cd_demo_sk
 order by c_customer_id
 limit 100;

-- end query 80 in stream 0 using template query84.tpl
