문제코드SELECT HG.EMP_NO, HE.EMP_NAME, (CASE WHEN AVG(HG.SCORE) >= 96 THEN 'S' WHEN AVG(HG.SCORE) = 90 THEN 'A' WHEN AVG(HG.SCORE) = 80 THEN 'B' ELSE 'C' END) AS GRADE, (CASE WHEN..
문제코드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..
황규진
Data Analyst Hwang