blob: a1076b57ced5c44c3ee5b96f94ec1b546e596901 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
SELECT
c_customer_id AS customer_id,
concat(c_last_name, ', ', c_first_name) AS customername
FROM customer
, customer_address
, customer_demographics
, household_demographics
, income_band
, store_returns
WHERE ca_city = 'Edgewood'
AND c_current_addr_sk = ca_address_sk
AND ib_lower_bound >= 38128
AND ib_upper_bound <= 38128 + 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
|