DataBase/SQL 연습문제
프로그래머스 SQL JOIN
문제 및 답변 (Level 2) 조건에 맞는 도서와 저자 리스트출력하기 -- Oracle SELECT BOOK_ID , AUTHOR_NAME , TO_CHAR(PUBLISHED_DATE, 'YYYY-MM-DD') AS PUBLISHED_DATE FROM BOOK JOIN AUTHOR ON BOOK.AUTHOR_ID = AUTHOR.AUTHOR_ID AND CATEGORY = '경제' ORDER BY PUBLISHED_DATE ASC; -- Mysql SELECT BOOK_ID , AUTHOR_NAME , DATE_FORMAT(PUBLISHED_DATE, '%Y-%m-%d') AS PUBLISHED_DATE FROM BOOK INNER JOIN AUTHOR ON BOOK.AUTHOR_ID = AUTHOR...
프로그래머스 SQL SELECT
문제 및 답변 (Level 2) 3월에 태어난 여성 회원 목록 출력하기 더보기 Oracle SELECT MEMBER_ID , MEMBER_NAME , GENDER , TO_CHAR(DATE_OF_BIRTH, 'YYYY-MM-DD') AS DATE_OF_BIRTH FROM MEMBER_PROFILE WHERE EXTRACT(MONTH FROM DATE_OF_BIRTH) = 3 AND GENDER = 'W' AND TLNO IS NOT NULL ORDER BY MEMBER_ID; Mysql SELECT MEMBER_ID , MEMBER_NAME , GENDER , DATE_FORMAT(DATE_OF_BIRTH,"%Y-%m-%d") as DATE_OF_BIRTH FROM MEMBER_PROFILE WHERE ..