GROUP BY, ORDER BY, LIMIT 이용SELECT months * salary AS earnings, COUNT(employee_id) AS cntFROM EmployeeGROUP BY earningsORDER BY earnings DESCLIMIT 1 WHERE절 서브쿼리 이용earnings의 값이 max_earnings와 동일한 경우를 WHERE절 서브쿼리를 통해 필터링SELECT months * salary AS earnings, COUNT(name)FROM employeeWHERE months * salary = (SELECT MAX(months * salary) FROM employee) -- SELECT의 AS 쓸 수 없음GROUP BY salary -- SEL..