Who is the director that made the most movies? Give the director's id.
director that made the most movies refers to MAX(COUNT(movie_id))
SELECT director_id FROM movies GROUP BY director_id ORDER BY COUNT(movie_id) DESC LIMIT 1