MySQL에서 if 함수 사용법

예)

SELECT IF(10 > 5, '크다', '작다') AS result;

 

---

select rv.first_name, rv.last_name, 
count(r.rating) as COUNT,
ifnull(min(r.rating),0) as MIN,
ifnull(max(r.rating),0) as MAX,
ifnull(avg(r.rating),0) as AVG,
if( count(r.rating) > 0 , 'ACTIVE' ,'INACTIVE') as STATUS
from reviewers rv
join reviews r
	on rv.id = r.reviewer_id
group by rv.id;