korsveien

select prodyear, title, firstname||' '||lastname as director
from person natural join film natural join filmitem natural join
filmparticipation
where parttype = 'director' and filmtype = 'TV' and prodyear = (
    select min(prodyear)
    from film natural join filmitem
    where filmtype = 'TV');

korsveien

select count(filmid), max(prodyear), min(prodyear)
from person natural join film natural join filmparticipation 
where parttype = 'director' and firstname = 'Anja' and lastname = 'Breien';