-- Creates a view showing actors with lots of movies

use wmdb;
drop view if exists popactors;

create view popactors(name,count) as
select name,count(name) as count
from person inner join credit using (nm)
group by nm
order by count desc;