15-10-2011, 13:30
|
|
|
חבר מתאריך: 15.10.11
הודעות: 1
|
|
לא מצליחה לעלות על הטעות
SELECT
customer
,
SUM
(price) as expenses,
COUNT
(quarter) as VisitsPerQuarter,
FROM
(
select
segment
,
(case when [expenses] > 370 and [visitsperquarter] > 3 then (VIP)
when [expenses] > 370 and [visitsperquarter] IN (1,2) then (gold)
when [expenses] >= 135 and [expenses] < 370 then (silver)
when [expenses] < 135 then bronze end)
as segment
from
dbo.Sales
|