DB 6일차 3(조건)

insert into
	score_mst
values
	(0,'신경수',100),
	(0,'고희주',95),
	(0,'장건녕',85),
	(0,'문승주',80),
	(0,'이승아',75),
	(0,'김수현',65),
	(0,'문경원',50);

 

/*
    grade
    90 ~ 100 A
    80 ~ 89 b
    70 ~ 79 c
    60 ~ 69 D
    0 ~ 59 F
    */

select
	*,    
case
	when(score>89 and score <101) then 'A'
	when(score>79) then 'B'
	when(score>69) then 'C'
	when(score>59) then 'D'
	when(score>0) then 'F'
    else 'X'
    end as grade        
from
	score_mst;

 

쌤이 한건

select
	*,    
	case
		when score < 0 or score > 100 then 'X'
    	when score between 90 and 100 then 'A'
    	when score between 80 and 89 then 'B'
   		when score between 70 and 79 then 'C'
    	when score between 60 and 69 then 'D'
    	else 'F'
    end as grade        
from
	score_mst;