본문 바로가기
728x90
320x100

💻 하나씩 차곡차곡/프로그래머스 (SQL)105

[SELECT/LEVEL1] 흉부외과 또는 일반외과 의사 목록 출력하기 (MySQL/Oracle) MySQLSELECT DR_NAME , DR_ID , MCDP_CD , DATE_FORMAT(HIRE_YMD, '%Y-%m-%d') AS HIRE_YMDFROM DOCTORWHERE MCDP_CD IN ('CS', 'GS')ORDER BY HIRE_YMD DESC, DR_NAME OracleSELECT DR_NAME , DR_ID , MCDP_CD , TO_CHAR(HIRE_YMD,'YYYY-MM-DD')FROM DOCTORWHERE MCDP_CD IN ('CS', 'GS')ORDER BY HIRE_YMD DESC, DR_NAME; 2023. 4. 3.
[SELECT/LEVEL1] 12세 이하인 여자 환자 목록 출력하기 (MySQL /Oracle) MySQLSELECT PT_NAME , PT_NO , GEND_CD , AGE , IFNULL(TLNO, 'NONE') AS TLNOFROM PATIENTWHERE AGE  OracleSELECT PT_NAME , PT_NO , GEND_CD , AGE , NVL(TLNO, 'NONE') AS TLNOFROM PATIENTWHERE AGE 2023. 4. 2.
[SELECT/LEVEL1] 과일로 만든 아이스크림 고르기 (MySQL/Oracle) MySQL/OracleSELECT A.FLAVORFROM FIRST_HALF A, ICECREAM_INFO BWHERE A.FLAVOR = B.FLAVOR AND A.TOTAL_ORDER > 3000 AND B.INGREDIENT_TYPE = 'fruit_based' 2023. 4. 1.
[SELECT/LEVEL1] 평균 일일 대여 요금 구하기 (MySQL/Oracle) MySQL/OracleSELECT ROUND(AVG(DAILY_FEE)) AS AVERAGE_FEEFROM CAR_RENTAL_COMPANY_CAR WHERE CAR_TYPE = 'SUV'; 2023. 3. 31.
[SELECT/LEVEL1] 인기있는 아이스크림 (MySQL/Oracle) MySQL/OracleSELECT FLAVORFROM FIRST_HALFORDER BY TOTAL_ORDER DESC, SHIPMENT_ID; 2023. 3. 30.
[SELECT/LEVEL1] 조건에 맞는 도서 리스트 출력하기 (MySQL/Oracle) MySQLSELECT BOOK_ID , DATE_FORMAT(PUBLISHED_DATE, '%Y-%m-%d') AS PUBLISHED_DATEFROM BOOKWHERE YEAR(PUBLISHED_DATE) = 2021AND CATEGORY = '인문'ORDER BY PUBLISHED_DATE;OracleSELECT BOOK_ID , TO_CHAR(PUBLISHED_DATE, 'YYYY-MM-DD') AS PUBLISHED_DATEFROM BOOKWHERE TO_CHAR(PUBLISHED_DATE, 'YYYY') = '2021'AND CATEGORY = '인문'ORDER BY PUBLISHED_DATE; 2023. 3. 29.
728x90
320x100

티스토리툴바