1.
SELECT DISTINCT A.stagename from movies.actors A, movies.casts C,
 movies.films F1, movies.films F2, movies.remakes R
WHERE C.actorid = A.actorid
 AND C.filmid = F1.filmid
 AND A.stagename <> 'sa'
 AND F1.filmid = R.originalId
 AND F2.filmid = R.remakeId

A.Bromley Davenport
A.E. Matthews
Aaron Schwartz
Abner Biberman
Achid Heeren
Adam West
Adam Williams
Adele Jergens
Adi Berber
Adolphe Menjou
Adriana Caselotti
...
Yvonne Shima
Yvonne deBray
Yvonne deCarlo
Zasu Pitts
Zeffie Tilbury
Zelma vanDias
Zena Marshall
Zia Mohyeddin
Zita Johann
Zoe Gail
leon Janney

2906 rows selected.

2.
SELECT DISTINCT F.title 
FROM movies.films F, movies.casts C, 
 movies.remakes R, movies.sayings S
WHERE F.filmid = C.filmid
 AND F.filmid = R.originalId
 AND S.filmid = F.filmid
 AND C.awards IS NOT NULL

TITLE
--------------------------------------------------
Casablanca
Gone with the Wind
The Philadelphia Story

3.
SELECT DISTINCT A.stagename
FROM movies.actors A, movies.sayings S1, movies.sayings S2, movies.casts C
WHERE C.actorid = A.actorid
 AND C.awards is not null
 AND S1.actorid = A.actorid
 AND S2.actorid = A.actorid
 AND S1.filmid <> S2.filmid

STAGENAME
-----------------------------------
Marlene Dietrich

4.
SELECT DISTINCT F.title
FROM movies.films F, movies.films first_film, movies.films second_film,
 movies.casts FC, movies.casts first_cast, movies.casts second_cast,
 movies.actors A,
 movies.specialawards SA, movies.specialawards SA2
WHERE FC.filmid = F.filmid
 AND first_cast.filmid = first_film.filmid
 AND second_cast.filmid = second_film.filmid

 AND FC.actorid = A.actorid
 AND first_cast.actorid = A.actorid
 AND second_cast.actorid = A.actorid
 AND first_film.year < second_film.year

 AND SA.actorid = A.actorid
 AND SA.year > second_film.year

 AND SA2.actorid = A.actorid
 AND SA2.year > second_film.year

 AND SA.specialawardid <> SA2.specialawardid

49th Parallel
A Bridge too Far
A Little Romance
Annie Oakley
As You Like It
B.F.'s Daughter
Baby Face
Ball of Fire
Banjo on my Knee
Blowing Wild
Carrie
...
The Strange Love of Martha Ivers
The Woman in Red
The Yellow Ticket
There's Always Tomorrow
These Wilder Years
Titanic
Uncle Vanya
Union Pacific
Variety Girl
Wild Geese II
Wuthering Heights

68 rows selected.

5.
(select DISTINCT A.stagename as name
 from movies.actors A, movies.specialawards SA
 where sa.year > 1990
  and SA.actorid = A.actorid)
union
(select DISTINCT P.personcode as name
 from movies.people P, movies.specialawards SA
 where sa.year > 1990
  and SA.peopleid = P.personid)

Myrna Loy
St.Kramer