You may need to use a recursive join $($AKA self join$)$ or a subquery to solve this problem.

Write a SQL query to rank the top $25$ production companies by the total number of films they have produced. Include the attributes and aliases shown in the example below. $(20$ points$)$

Hints:

To add a rank column you could use either the ROW$\_$NUMBERO or RANKO windowing function. Choose the most appropriate for the problem.

This problem is a good candidate to solve with a CIE query for extra credit.

To limit the results to the top $25$ you can use Mysol's LiMII clouse like this: