SELECT id, title FROM movie
WHERE yr=1962
SELECT yr FROM movie
WHERE title = 'Citizen Kane'
SELECT id, title, yr FROM movie
WHERE title LIKE 'Star Trek%'
ORDER BY yr
SELECT id FROM actor
WHERE name = 'Glenn Close'
SELECT id FROM movie
WHERE title = 'Casablanca'
Use movieid=11768, (or whatever value you got from the previous question)
SELECT name FROM actor JOIN casting ON (id = actorid)
WHERE movieid = '27
SELECT name FROM actor JOIN casting ON (id = actorid)
WHERE movieid = (SELECT id FROM movie WHERE title = 'Alien')
SELECT title FROM movie JOIN casting ON (id = movieid)
WHERE actorid = (SELECT id FROM actor WHERE name = 'Harrison Ford')
SELECT title FROM movie JOIN casting ON (id = movieid)
WHERE ord !=1
AND actorid = (SELECT id FROM actor WHERE name = 'Harrison Ford')
SELECT title, name FROM movie
JOIN casting ON (movie.id = casting.movieid)
JOIN actor ON (casting.actorid = actor.id)
WHERE yr = 1962
AND ord = 1
SELECT yr, COUNT(title) FROM movie
JOIN casting ON (movie.id=movieid)
JOIN actor ON (actorid=actor.id)
WHERE name = 'Rock Hudson'
GROUP BY yr
HAVING COUNT(title) > 1
SELECT title, name FROM movie
JOIN casting ON (movie.id = movieid)
JOIN actor ON (actorid = actor.id)
WHERE ord = 1
AND movieid IN
(SELECT movieid FROM casting, actor
WHERE actorid = id
AND name = 'Julie Andrews')
SELECT name FROM actor JOIN casting ON (id = actorid)
WHERE ord = 1
GROUP BY name
HAVING 14 < COUNT(name)
SELECT title,COUNT(actorid) FROM movie JOIN casting ON (id = movieid)
WHERE yr = '1978'
GROUP BY title
ORDER BY COUNT(actorid) DESC , title
SELECT name FROM actor
JOIN casting ON (actor.id = actorid)
JOIN movie ON (movieid = movie.id)
WHERE movieid IN
(SELECT movieid FROM movie,casting,actor
WHERE actorid = actor.id
AND name = 'Art Garfunkel' )
AND name != 'Art Garfunkel'
ORDER BY name
Good