sql view1 [SQL] DATA MANIPULATION LANGUAGE SELECT director, AVG(rating) AS avg_rating FROM movies WHERE rating IS NOT NULL AND director IS NOT NULL GROUP BY director HAVING COUNT(*) >= 5 ORDER BY avg_rating DESC;-- 작품이 5개 이상인 감독들을 평균 rating 순으로 정렬 SELECT genres, COUNT(*) AS number_of_movies FROM movies GROUP BY genres ORDER BY number_of_movies DESC;-- 각 장르에 몇 편의 영화가 있는지 SELECT COUNT(*) AS higher_than_six FROM movies WHERE rating.. 2025. 2. 6. 이전 1 다음