728x90 320x100 💻 하나씩 차곡차곡363 [GROUP BY/LEVEL2] 특정 조건을 만족하는 물고기별 수와 최대 길이 구하기 (MySQL) MySQLSELECT COUNT(*) AS FISH_COUNT , MAX(IFNULL(LENGTH, 10)) AS MAX_LENGTH , FISH_TYPEFROM FISH_INFOGROUP BY FISH_TYPEHAVING AVG(IFNULL(LENGTH, 10)) >= 33ORDER BY FISH_TYPE 2024. 12. 2. [GROUP BY/LEVEL3] 카테고리 별 도서 판매량 집계하기 (MySQL) MySQLSELECT CATEGORY, SUM(SALES) AS TOTAL_SALESFROM BOOK A, BOOK_SALES B WHERE A.BOOK_ID = B.BOOK_IDAND YEAR(SALES_DATE) = 2022AND MONTH(SALES_DATE) = 1GROUP BY CATEGORYORDER BY CATEGORY 2024. 11. 29. [GROUP BY/LEVE2] 월별 잡은 물고기 수 구하기 (MySQL) MySQLSELECT COUNT(*) AS FISH_COUNT, MONTH(TIME) AS MONTHFROM FISH_INFOGROUP BY MONTH(TIME)ORDER BY MONTH 2024. 11. 28. [GROUP BY/LEVEL2] 물고기 종류 별 잡은 수 구하기 (MySQL) MySQLSELECT COUNT(*) AS FISH_COUNT , FISH_NAMEFROM FISH_INFO A, FISH_NAME_INFO BWHERE A.FISH_TYPE = B.FISH_TYPEGROUP BY FISH_NAMEORDER BY FISH_COUNT DESC 2024. 11. 27. [GROUP BY/LEVEL2] 노선별 평균 역 사이 거리 조회하기 (MySQL) MySQLSELECT ROUTE , CONCAT(ROUND(SUM(D_BETWEEN_DIST), 1), 'km') AS TOTAL_DISTANCE , CONCAT(ROUND(AVG(D_BETWEEN_DIST), 2), 'km') AS AVERAGE_DISTANCEFROM SUBWAY_DISTANCEGROUP BY ROUTEORDER BY ROUND(SUM(D_BETWEEN_DIST), 1) DESC; 2024. 11. 26. [GROUP BY/LEVEL2] 조건에 맞는 사원 정보 조회하기 (MySQL) MySQLSELECT SUM(SCORE) AS SCORE , C.EMP_NO , B.EMP_NAME , B.POSITION , B.EMAILFROM HR_DEPARTMENT A, HR_EMPLOYEES B, HR_GRADE CWHERE A.DEPT_ID = B.DEPT_IDAND B.EMP_NO = C.EMP_NOGROUP BY C.EMP_NO , B.EMP_NAME , B.POSITION , B.EMAILORDER BY SCORE DESCLIMIT 1 2024. 11. 25. 이전 1 2 3 4 5 6 7 ··· 61 다음 728x90 320x100