blob: edb70276911ff93a088eeb6363f0363b18070a84 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
|
--!syntax_pg
--TPC-DS Q84
-- start query 1 in stream 0 using template ../query_templates/query84.tpl
select c_customer_id as customer_id
, coalesce(c_last_name,'') || ', ' || coalesce(c_first_name,'') as customername
from plato.customer
,plato.customer_address
,plato.customer_demographics
,plato.household_demographics
,plato.income_band
,plato.store_returns
where ca_city = 'Hopewell'
and c_current_addr_sk = ca_address_sk
and ib_lower_bound >= 32287
and ib_upper_bound <= 32287 + 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 ../query_templates/query84.tpl
|
