/*c) finne tittel på alle filmer regissert av Francis Ford Coppola*/
/*query*/
fdb=> select title
fdb-> from film natural join filmparticipation natural join person
fdb-> where parttype = 'director' and lastname = 'Coppola' and firstname = 'Francis Ford';
/*result*/

               title
-----------------------------------
 Apocalypse Now
 Bellboy and the Playgirls, The
 Captain EO
 Conversation, The
 Cotton Club, The
 Dementia 13
 Dracula
 Finian's Rainbow
 Gardens of Stone
 Godfather Trilogy: 1901-1980, The
 Godfather, The
 Godfather: Part II, The
 Godfather: Part III, The
 Jack
 Making 'Bram Stoker's Dracula'
 Nebo zovyot
 New York Stories
 One from the Heart
 Outsiders, The
 Peggy Sue Got Married
 Rain People, The
 Rainmaker, The
 Rumble Fish
 Supernova
 Terror, The
 Tetro
 Tonight for Sure
 Tucker: The Man and His Dream
 You're a Big Boy Now
 Youth Without Youth
(30 rows)