0001 SELECT
0002 c_customer_id AS customer_id,
0003 concat(c_last_name, ', ', c_first_name) AS customername
0004 FROM customer
0005 , customer_address
0006 , customer_demographics
0007 , household_demographics
0008 , income_band
0009 , store_returns
0010 WHERE ca_city = 'Edgewood'
0011 AND c_current_addr_sk = ca_address_sk
0012 AND ib_lower_bound >= 38128
0013 AND ib_upper_bound <= 38128 + 50000
0014 AND ib_income_band_sk = hd_income_band_sk
0015 AND cd_demo_sk = c_current_cdemo_sk
0016 AND hd_demo_sk = c_current_hdemo_sk
0017 AND sr_cdemo_sk = cd_demo_sk
0018 ORDER BY c_customer_id
0019 LIMIT 100
