#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