조건에 맞는 회원수 구하기

SELECT COUNT(USER_ID) AS USERS 
FROM USER_INFO
WHERE AGE >19 AND AGE <30 AND JOINED LIKE '2021-%'

#WHERE JOINED <= '2021-12-31' AND AGE BETWEEN 20 AND 29