inblog logo
|
silver
    SQL문제풀기

    [SQL문제풀기] 조건에 맞는 회원수 구하기

    silver's avatar
    silver
    Nov 22, 2024
    [SQL문제풀기] 조건에 맞는 회원수 구하기
     

    문제

    school.programmers.co.kr
    https://school.programmers.co.kr/learn/courses/30/lessons/131535?language=oracle
     

    내가 작성한 정답

    ORACLE
    SELECT COUNT(*) FROM USER_INFO WHERE (AGE BETWEEN 20 AND 29) AND (TO_CHAR(JOINED,'YYYY') = 2021);
    MYSQL
    SELECT COUNT(*) FROM USER_INFO WHERE(AGE BETWEEN 20 AND 29) AND (DATE_FORMAT(JOINED,'%Y') = 2021);
     
    💡
    MYSQL에서 날짜형식 바꾸는 함수
    DATE_FORMAT(now(), '%Y%m%d%H%i%s')
     
    Share article

    silver

    RSS·Powered by Inblog