728x90 320x100 💻 하나씩 차곡차곡/프로그래머스 (SQL)105 [SELECT/LEVEL3] 대장균들의 자식의 수 구하기 (MySQL) MySQLSELECT A.ID, IFNULL(COUNT(B.ID), 0) AS CHILD_COUNTFROM ECOLI_DATA A LEFT OUTER JOIN ECOLI_DATA BON A.ID = B.PARENT_IDGROUP BY A.IDORDER BY ID 2024. 11. 1. [SELETE/LEVEL2] 조건에 맞는 개발자 찾기 (MySQL) MySQLSELECT ID, EMAIL, FIRST_NAME, LAST_NAMEFROM DEVELOPERSWHERE SKILL_CODE & (SELECT CODE FROM SKILLCODES WHERE NAME = 'Python') OR SKILL_CODE & (SELECT CODE FROM SKILLCODES WHERE NAME = 'C#')ORDER BY ID; 2024. 10. 31. [SUM, MAX, MIN/LEVEL3] 물고기 종류 별 대어 찾기 (MySQL) MySQLSELECT A.ID , B.FISH_NAME , A.LENGTHFROM FISH_INFO A, FISH_NAME_INFO BWHERE A.FISH_TYPE = B.FISH_TYPEAND( A.FISH_TYPE, A.LENGTH ) IN (SELECT FISH_TYPE, MAX(LENGTH) FROM FISH_INFO GROUP BY FISH_TYPE ) 2024. 10. 30. [SUM, MAX, MIN/LEVEL2] 연도별 대장균 크기의 편차 구하기 (MySQL) MySQLSELECT YEAR(DIFFERENTIATION_DATE) AS YEAR , MAX_SIZE_OF_COLONY - SIZE_OF_COLONY AS YEAR_DEV , IDFROM ECOLI_DATA A, ( SELECT YEAR(DIFFERENTIATION_DATE) AS YEAR , MAX(SIZE_OF_COLONY) AS MAX_SIZE_OF_COLONY FROM ECOLI_DATA GROUP BY YEAR(DIFFERENTIATION_DATE) ) BWHERE YEAR(DIFFERENTIATION_DATE) = B.YEARORDER.. 2024. 10. 29. [SUM, MAX, MIN/LEVEL2] 조건에 맞는 아이템들의 가격의 총합 구하기 (MySQL) MySQLSELECT SUM(PRICE) AS TOTAL_PRICEFROM ITEM_INFOWHERE RARITY = 'LEGEND' 2024. 10. 28. [SUM, MAX, MIN/LEVEL1] 잡은 물고기 중 가장 큰 물고기의 길이 구하기 (MySQL) MySQLSELECT CONCAT(MAX(LENGTH), 'cm') MAX_LENGTHFROM FISH_INFO 2024. 10. 25. 이전 1 2 3 4 5 6 7 8 ··· 18 다음 728x90 320x100