if 쿼리 사용하기

select sum( if (month>='01' and month <'04' , 1, 0) ) as msum from test if ( 조건, 참일경우 값, 거짓일 경우 값) 예) SELECT a.*, SUM( if(b.reg_date>='2022-01-01' AND b.reg_date<'2022-01-31', b.score, 0) ) AS score1, SUM( if(b.reg_date>='2022-01-01' AND b.reg_date<'2022-04-01', b.score, 0) ) AS score2, SUM( if(b.reg_date>='2022-01-01' AND b.reg_date<'2023-01-01', b.score, 0) ) AS score3 FROM USER_ACCOUNT a LEFT OUTER JOIN USER_SCORE b ON a.user_id=b.user_id...