[프로그래머스 - ORACLE] 조건에 맞는 회원수 구하기

---

CREATE 문

CREATE TABLE USER_INFO  (
USER_ID		NUMBER		NOT NULL,
GENDER		NUMBER		NULL,
AGE		NUMBER		NULL,
JOINED		DATE		NOT NULL
)

 

---

• 내 풀이

SELECT
    COUNT(USER_ID)
FROM USER_INFO
WHERE TO_CHAR(JOINED , 'YYYY') = '2021'
AND AGE BETWEEN  20 AND  29;