-- Q1: directors

NAME
--------------------------------
Mel Brooks
Wolfgang Petersen
Brian G Hutton
George Lucas
Irvin Kershner
Richard Marquand
Kevin Reynolds
Sir Laurence Olivier
Martin Brest
Brian De Palma
Sidney Lumet

NAME
--------------------------------
Alan Parker
Robert Zemeckis
Franklin J Schaffner
Richard Attenborough
David Attenborough
Oliver Stone
David Lean
Bernardo Bertolucci

19 rows selected.

-- Q2: female actors


NAME
--------------------------------
Teri Garr
Madelaine Kahn
Diane Lane
Carrie Fisher
Irene Cara
Michelle Pfeiffer
Sally Field
Joan Chen

8 rows selected.

-- Q3: actors in Scarface


NAME
--------------------------------
Al Pacino
Michelle Pfeiffer

-- Q4: titles of Guinness's films


TITLE
--------------------------------
A New Hope
Lawrence of Arabia

-- Q5: names of actors in films directed by Alan Parker


NAME
--------------------------------
Irene Cara
Brad Davis