[SQL]문법정리8(case)

SELECT pu.user_id , pu.point ,
(
CASE when pu.point > 10000 then '잘 하고 있어요!'
ELSE '조금난 더 파이팅!'
END) as msg
FROM point_users pu ;

SELECT pu.user_id , pu.point ,
(
CASE when pu.point > 10000 then '1만 이상 '
WHEN pu.point > 5000 then '5천 이상'
ELSE '5천 미만'
END) as lv
FROM point_users pu ;

SELECT a.lv,
COUNT(*) as cnt
FROM (
SELECT pu.user_id , pu.point ,
(
CASE when pu.point > 10000 then '1만 이상 '
WHEN pu.point > 5000 then '5천 이상'
ELSE '5천 미만'
END) as lv
FROM point_users pu
) a
group by a.lv;

with table1 as
(
SELECT pu.user_id , pu.point ,
(
CASE when pu.point > 10000 then '1만 이상 '
WHEN pu.point > 5000 then '5천 이상'
ELSE '5천 미만'
END) as lv
FROM point_users pu
)
SELECT a.lv,COUNT(*) as cnt FROM table1 a
group by a.lv;