SQL124 [프로그래머스 / SQL] 대장균들의 자식의 수 구하기 -CodeSELECT ED1.ID, COUNT(ED2.ID) AS CHILD_COUNTFROM ECOLI_DATA AS ED1 LEFT JOIN ECOLI_DATA AS ED2 ON ED1.ID = ED2.PARENT_IDGROUP BY ED1.IDORDER BY ED1.ID; 2025. 7. 27. [프로그래머스 / SQL] 업그레이드 할 수 없는 아이템 구하기 -CodeSELECT ITEM_ID, ITEM_NAME, RARITYFROM ITEM_INFOWHERE ITEM_ID NOT IN ( SELECT PARENT_ITEM_ID FROM ITEM_TREE WHERE PARENT_ITEM_ID IS NOT NULL )ORDER BY ITEM_ID DESC; 2025. 7. 27. [프로그래머스 / SQL] 대여 횟수가 많은 자동차들의 월별 대여 횟수 구하기 -CodeSELECT MONTH(START_DATE) AS MONTH, CAR_ID, COUNT(*) AS RECORDSFROM CAR_RENTAL_COMPANY_RENTAL_HISTORYWHERE START_DATE BETWEEN '2022-08-01' AND '2022-11-01' AND CAR_ID IN ( SELECT CAR_ID FROM CAR_RENTAL_COMPANY_RENTAL_HISTORY WHERE START_DATE BETWEEN '2022-08-01' AND '2022-11-01' GROUP BY CAR_ID .. 2025. 7. 26. [프로그래머스 / SQL] 헤비 유저가 소유한 장소 -CodeSELECT ID, NAME, HOST_IDFROM PLACES WHERE HOST_ID IN ( SELECT HOST_ID FROM PLACES GROUP BY HOST_ID HAVING COUNT(HOST_ID) > 1 ); 2025. 7. 26. [프로그래머스 / SQL] 특정 조건을 만족하는 물고기별 수와 최대 길이 구하기 CodeSELECT COUNT(*) AS FISH_COUNT, MAX(LENGTH) AS MAX_LENGTH, FISH_TYPEFROM FISH_INFOGROUP BY FISH_TYPEHAVING AVG(IFNULL(LENGTH, 10)) >= 33ORDER BY FISH_TYPE; 2025. 7. 25. [프로그래머스 / SQL] 조회수가 가장 많은 중고거래 게시판의 첨부파일 조회하기 -CodeSELECT CONCAT( '/home/grep/src/', UGF.BOARD_ID, '/', UGF.FILE_ID, UGF.FILE_NAME, FILE_EXT ) AS FILE_PATHFROM USED_GOODS_BOARD AS UGB JOIN USED_GOODS_FILE AS UGF ON UGB.BOARD_ID = UGF.BOARD_IDWHERE UGB.VIEWS = ( SELECT MAX(VIEWS) FROM USED_GOODS_BOARD )ORDER BY UGF.FILE_ID DESC; 2025. 7. 25. 이전 1 ··· 4 5 6 7 8 9 10 ··· 21 다음
