[MYSQL]조건에 맞는 회원수 구하기

SELECT Count(*) AS USERS FROM USER_INFO WHERE AGE BETWEEN 20 AND 29 AND YEAR(JOINED) = 2021

SELECT SUM(USERS) AS USERS 
	FROM(SELECT IF(AGE >= 20 && AGE <= 29, 1,0) AS USERS 
    		FROM USER_INFO 
           	 WHERE JOINED LIKE '2021-%')A;