-- Creates a view showing movies with lots of actors:

use wmdb;
drop view if exists popmovies;

create view popmovies(title,count) as
select title,count(title) as count
from credit inner join movie using (tt)
group by tt
order by count desc;