![]()
문제코드SELECT BOARD_ID, WRITER_ID, TITLE, PRICE, CASE WHEN STATUS = 'DONE' THEN '거래완료' WHEN STATUS = 'RESERVED' THEN '예약중' ELSE '판매중' END AS 'STATUS'FROM USED_GOODS_BOARDWHERE CREATED_DATE = '2022-10-05'ORDER BY BOARD_ID DESC..
![]()
문제코드SELECT COUNT(ID) AS FISH_COUNT, MONTH(TIME) AS 'MONTH'FROM FISH_INFOGROUP BY 2HAVING 1 IS NOT NULLORDER BY 2; 출처: 프로그래머스 코딩 테스트 연습, https://school.programmers.co.kr/learn/courses/30/lessons/293260
![]()
문제코드SELECT ITEM_INFO.ITEM_ID, ITEM_NAMEFROM ITEM_INFO JOIN ITEM_TREE ON ITEM_INFO.ITEM_ID = ITEM_TREE.ITEM_IDWHERE PARENT_ITEM_ID IS NULLORDER BY ITEM_ID; 출처: 프로그래머스 코딩 테스트 연습, https://school.programmers.co.kr/learn/courses/30/lessons/273710
![]()
문제코드SELECT COUNT(ID) AS FISH_COUNT, FISH_NAMEFROM FISH_INFO JOIN FISH_NAME_INFO ON FISH_INFO.FISH_TYPE = FISH_NAME_INFO.FISH_TYPEGROUP BY FISH_NAMEORDER BY 1 DESC; 출처: 프로그래머스 코딩 테스트 연습, https://school.programmers.co.kr/learn/courses/30/lessons/293257
![]()
문제코드SELECT YEAR(YM) AS YEAR, ROUND(AVG(PM_VAL1),2) AS 'PM10', ROUND(AVG(PM_VAL2),2) AS 'PM2.5'FROM AIR_POLLUTIONWHERE LOCATION1 = '경기도' AND LOCATION2 = '수원'GROUP BY 1ORDER BY 1; 출처: 프로그래머스 코딩 테스트 연습, https://school.programmers.co.kr/learn/courses/30/lessons/284530
![]()
문제코드SELECT FLOOR(PRICE / 10000) * 10000 AS PRICE_GROUP, COUNT(PRODUCT_ID) AS PRODUCTSFROM PRODUCTGROUP BY PRICE_GROUPORDER BY PRICE_GROUP; 출처: 프로그래머스 코딩 테스트 연습, https://school.programmers.co.kr/learn/courses/30/lessons/131530
