blob: ba83c5a18e5b9eb7da66a34b783347cd9786aca2 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
|
-- start query 1 in stream 0 using template query84.tpl and seed 1819994127
select c_customer_id as customer_id
, coalesce(c_last_name,'') || ', ' || coalesce(c_first_name,'') as customername
from customer
,customer_address
,customer_demographics
,household_demographics
,income_band
,store_returns
where ca_city = 'Hopewell'
and c_current_addr_sk = ca_address_sk
and ib_lower_bound >= 37855
and ib_upper_bound <= 37855 + 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 1 in stream 0 using template query84.tpl
|