문제코드SELECT FIRST_HALF.FLAVORFROM JULY LEFT JOIN FIRST_HALF ON JULY.FLAVOR = FIRST_HALF.FLAVORGROUP BY JULY.FLAVORORDER BY FIRST_HALF.TOTAL_ORDER + SUM(JULY.TOTAL_ORDER) DESCLIMIT 3 출처: 프로그래머스 코딩 테스트 연습, https://school.programmers.co.kr/learn/courses/30/lessons/133027
문제코드SELECT DISTINCT CART_IDFROM CART_PRODUCTSWHERE CART_ID IN (SELECT DISTINCT CART_ID FROM CART_PRODUCTS WHERE NAME = 'Milk') AND CART_ID IN (SELECT DISTINCT CART_ID FROM CART_PRODUCTS WHERE NAME = 'Yogurt') 출처: 프로그래머스 코딩 테스트 연습, https://school.programmers.co.kr/learn/courses/30/lessons/62284
문제코드SELECT REST_INFO.REST_ID, REST_NAME, FOOD_TYPE, FAVORITES, ADDRESS, ROUND(AVG(REVIEW_SCORE),2) AS SCOREFROM REST_INFO JOIN REST_REVIEW ON REST_INFO.REST_ID = REST_REVIEW.REST_IDWHERE REST_INFO.ADDRESS LIKE '서울%'GROUP BY REST_INFO.REST_ID, REST_NAME, FOOD_TYPE, FAVORITES, ADDRESSORDER BY SCORE DESC, FAVORITES DESC 출처: 프로그래머스 코딩 테스트 연습, https://school.programmers.co.kr/learn/co..
문제코드SELECT BOOK.AUTHOR_ID, AUTHOR.AUTHOR_NAME, BOOK.CATEGORY , SUM(BOOK_SALES.SALES * BOOK.PRICE) AS TOTAL_SALESFROM BOOK JOIN AUTHOR ON BOOK.AUTHOR_ID = AUTHOR.AUTHOR_ID JOIN BOOK_SALES ON BOOK.BOOK_ID = BOOK_SALES.BOOK_IDWHERE DATE_FORMAT(BOOK_SALES.SALES_DATE, '%Y-%m') = '2022-01'GROUP BY BOOK.AUTHOR_ID, BOOK.CATEGORYORDER BY BOOK.AUTHOR_ID, BOOK.CATEGORY DESC 출처: 프로그래머스 코딩 테스트 연습,..
문제코드SELECT YEAR(ONLINE_SALE.SALES_DATE) AS YEAR, MONTH(ONLINE_SALE.SALES_DATE) AS MONTH, USER_INFO.GENDER, COUNT(DISTINCT ONLINE_SALE.USER_ID) AS USERSFROM USER_INFOJOIN ONLINE_SALE ON USER_INFO.USER_ID = ONLINE_SALE.USER_IDWHERE USER_INFO.GENDER IS NOT NULLGROUP BY YEAR(ONLINE_SALE.SALES_DATE), MONTH(ONLINE_SALE.SALES_DATE), USER_INFO.GENDERORDER BY Y..
문제코드SELECT APPOINTMENT.APNT_NO, PATIENT.PT_NAME, PATIENT.PT_NO, DOCTOR.MCDP_CD, DOCTOR.DR_NAME, APPOINTMENT.APNT_YMDFROM DOCTOR JOIN APPOINTMENT ON DOCTOR.DR_ID = APPOINTMENT.MDDR_ID JOIN PATIENT ON PATIENT.PT_NO = APPOINTMENT.PT_NOWHERE APPOINTMENT.APNT_CNCL_YN = 'N' AND DOCTOR.MCDP_CD = 'CS' AND DATE_FORMAT(APPOINTMENT.APNT..
황규진
Data Analyst Hwang