-- Creates a filmography view for all people

use wmdb;
drop view if exists filmography;

create view filmography(name,title) as
select name,title
from person inner join credit using (nm) inner join movie using (tt);