Movies per Decade
GROUP BY on a computed decade bucket
Top Genres by Rating
GROUP BY + HAVING: genres with at least 50 rated movies
Documentary
2,589 movies
Biography
2,611 movies
Film-Noir
463 movies
History
1,941 movies
War
1,238 movies
Music
1,494 movies
Animation
1,630 movies
Musical
857 movies
Sport
924 movies
Drama
27,468 movies
Most Prolific Actors
COUNT of credits, ordered descending
1
P
Prakash Raj
154 movies
2
N
Nassar
151 movies
3
A
Anupam Kher
142 movies
4
A
Akshay Kumar
139 movies
5
A
Amitabh Bachchan
134 movies
6
M
Mohanlal
117 movies
7
P
Paresh Rawal
117 movies
8
B
Brahmanandam
114 movies
9
T
Tanikella Bharani
114 movies
10
M
Michael Caine
110 movies