SQL query produces results which display COUNT(movie.mov_title) as the result in the COUNT(movie.mov_title) column. How can it be modified to produce a numerical result?

 

Transcribed Image Text:

Show the director and movie count for the director with the most movies SELECT dir_firstName, dir lastName, "COUNT (movie.mov_title)" FROM ( SELECT director.dir firstName, director.dir lastName, COUNT (movie.mov_title) AS COUNT (movie.mov_title)", RANK ( ) OVER (ORDER BY COUNT (movie.mov title) DESC) AS RankNum FROM director LEFT JOIN movie ON director.id = movie.dir id GROUP BY director.dir_firstName, director.dir lastName ) AS subquery WHERE RankNum = 1; Show the director and movie count for the director with the most movies SELECT dir_firstName, dir lastName, "COUNT (movie.mov_title)" FROM ( SELECT director.dir firstName, director.dir lastName, COUNT (movie.mov_title) AS COUNT (movie.mov_title)", RANK ( ) OVER (ORDER BY COUNT (movie.mov title) DESC) AS RankNum FROM director LEFT JOIN movie ON director.id = movie.dir id GROUP BY director.dir_firstName, director.dir lastName ) AS subquery WHERE RankNum = 1;

Answer rating: 100% (QA)

The SQL query provided is already producing a numerical result in the COUNTmoviemovtitle column This ... View the full answer