blob: fdb9f38e294f7ffe08f1e2b32fb72c10486a1587 (
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
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
|
SELECT sum(ss_quantity)
FROM store_sales, store, customer_demographics, customer_address, date_dim
WHERE s_store_sk = ss_store_sk
AND ss_sold_date_sk = d_date_sk AND d_year = 2001
AND
(
(
cd_demo_sk = ss_cdemo_sk
AND
cd_marital_status = 'M'
AND
cd_education_status = '4 yr Degree'
AND
ss_sales_price BETWEEN 100.00 AND 150.00
)
OR
(
cd_demo_sk = ss_cdemo_sk
AND
cd_marital_status = 'D'
AND
cd_education_status = '2 yr Degree'
AND
ss_sales_price BETWEEN 50.00 AND 100.00
)
OR
(
cd_demo_sk = ss_cdemo_sk
AND
cd_marital_status = 'S'
AND
cd_education_status = 'College'
AND
ss_sales_price BETWEEN 150.00 AND 200.00
)
)
AND
(
(
ss_addr_sk = ca_address_sk
AND
ca_country = 'United States'
AND
ca_state IN ('CO', 'OH', 'TX')
AND ss_net_profit BETWEEN 0 AND 2000
)
OR
(ss_addr_sk = ca_address_sk
AND
ca_country = 'United States'
AND
ca_state IN ('OR', 'MN', 'KY')
AND ss_net_profit BETWEEN 150 AND 3000
)
OR
(ss_addr_sk = ca_address_sk
AND
ca_country = 'United States'
AND
ca_state IN ('VA', 'CA', 'MS')
AND ss_net_profit BETWEEN 50 AND 25000
)
)
|
