DAY 4 - 집계함수

 

GROUP BY에 없는 컬럼 → SELECT에서 집계함수로 감싸거나 GROUP BY에 추가!

 

select local, COUNT(location_id) AS num_locations
from location
GROUP BY local
ORDER BY num_locations ASC;