SQL

물고기 데이터 (FISH_INFO) 🐟[특정 조건을 만족하는 물고기별 수와 최대 길이 구하기] (GROUP BY)WITH W1 AS ( SELECT FISH_TYPE, AVG(COALESCE(LENGTH, 10)) AS AVG_LEN, MAX(COALESCE(LENGTH, 10)) AS MAX_LEN, COUNT(ID) AS CNT FROM FISH_INFO GROUP BY FISH_TYPE HAVING AVG_LEN >= 33 )SELECT CNT AS FISH_COUNT, MAX_LEN AS MAX_LENGTH, FISH_TYPEFROM W1ORDER BY FISH_TYPE ASCCTE (Common Table Expressio..