quote:

---

Originally posted by jassi.singh

Please post your full query though i tried and check below one
select customer,
SUM(price) as expenses,
COUNT(quarter) as VisitsPerQuarter
FROM

(

select

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) temp


Please mark answer as accepted if it helped you.

Thanks,
Jassi Singh

---

SELECT
customer,
SUM(price) as expenses,
VisitsPerQuarter
FROM

(

select

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,customer,price,
COUNT(1) OVER (PARTITION BY quarter) as VisitsPerQuarter
from dbo.Sales
)t
GROUP BY customer