#05. SELECT : 흉부외과 또는 일반외과 의사 목록 출력하기 | 프로그래머스 | SQL 고득점 Kit

문제 입력 코드 1. WHERE - OR SELECT DR_NAME, DR_ID, MCDP_CD, DATE_FORMAT(HIRE_YMD, "%Y-%m-%d") AS HIRE_YMD FROM DOCTOR WHERE (MCDP_CD = 'CS') OR (MCDP_CD = 'GS') ORDER BY HIRE_YMD DESC, DR_NAME ASC; 2. WHERE - IN SELECT DR_NAME, DR_ID, MCDP_CD, DATE_FORMAT(HIRE_YMD, "%Y-%m-%d") AS HIRE_YMD FROM DOCTOR WHERE MCDP_CD IN ('CS', 'GS') ORDER BY HIRE_YMD DESC, DR_NAME ASC; 코드 설명 #SELECT #DATE_FORMAT #WHERE ..

• format_list_bulleted SQL
• · 2023. 5. 20.
• textsms

#04. SELECT : 강원도에 위치한 생산공장 목록 출력하기 | 프로그래머스 | SQL 고득점 Kit

문제 입력 코드 1. LIKE SELECT FACTORY_ID, FACTORY_NAME, ADDRESS FROM FOOD_FACTORY WHERE ADDRESS LIKE '강원도%' ORDER BY FACTORY_ID ASC; 2. LEFT SELECT FACTORY_ID, FACTORY_NAME, ADDRESS FROM FOOD_FACTORY WHERE LEFT(TLNO,3)=033 → 강원도 지역번호(033)으로 조회 LEFT(문자열, 길이) 함수 문자열을 받아서 왼쪽부터 원하는 길이만큼 자르는 함수 3. SUBSTRING SELECT FACTORY_ID, FACTORY_NAME, ADDRESS FROM FOOD_FACTORY WHERE SUBSTRING(ADDRESS, 1, 3) = '강원도' OR..

• format_list_bulleted SQL
• · 2023. 5. 19.
• textsms

#03. SELECT : 조건에 부합하는 중고거래 댓글 조회하기 | 프로그래머스 | SQL 고득점 Kit

문제 입력 코드 1. AND SELECT board.TITLE, board.BOARD_ID, reply.REPLY_ID, reply.WRITER_ID, reply.CONTENTS, DATE_FORMAT(reply.CREATED_DATE, '%Y-%m-%d') AS CREATED_DATE FROM USED_GOODS_BOARD as board JOIN USED_GOODS_REPLY AS reply ON board.BOARD_ID = reply.BOARD_ID WHERE (board.CREATED_DATE >= '2022-10-01') AND (board.CREATED_DATE

• format_list_bulleted SQL
• · 2023. 5. 19.
• textsms

#02. SELECT : 과일로 만든 아이스크림 고르기 | 프로그래머스 | SQL 고득점 Kit

문제 입력 코드 1. JOIN SELECT shipment.FLAVOR FROM FIRST_HALF AS shipment JOIN ICECREAM_INFO AS info ON shipment.FLAVOR = info.FLAVOR WHERE (shipment.TOTAL_ORDER > 3000) AND (info.INGREDIENT_TYPE = 'fruit_based') ORDER BY shipment.TOTAL_ORDER DESC; 2. SUB QUERY SELECT FLAVOR FROM FIRST_HALF WHERE FLAVOR IN (SELECT FLAVOR FROM ICECREAM_INFO WHERE INGREDIENT_TYPE='fruit_based') AND TOTAL_ORDER > 3000 OR..

• format_list_bulleted SQL
• · 2023. 5. 17.
• textsms

#01. SELECT : 3월에 태어난 여성 회원 목록 출력하기 | 프로그래머스 | SQL 고득점 Kit

문제 입력 코드 SELECT MEMBER_ID, MEMBER_NAME, GENDER, DATE_FORMAT(DATE_OF_BIRTH, "%Y-%m-%d") AS DATE_OF_BIRTH FROM MEMBER_PROFILE WHERE GENDER='W' AND TLNO IS NOT NULL AND DATE_FORMAT(DATE_OF_BIRTH, '%m')='03' ORDER BY MEMBER_ID 코드 설명 # SELECT #DATE_FORMAT #WHERE #ORDER BY 문제 출처 https://school.programmers.co.kr/learn/courses/30/lessons/131120

• format_list_bulleted SQL
• · 2023. 5. 16.
• textsms