gideondsouza

SELECT title
FROM movie
WHERE id in (11768, 11955, 21191)

gideondsouza

SELECT id
FROM actor
WHERE name='Glenn Close'

gideondsouza

SELECT id
FROM movie
Where title = 'Casablanca'

gideondsouza

SELECT a.Name 
FROM
casting c
JOIN actor a ON
c.actorid = a.id
Where movieid = 27

gideondsouza

SELECT a.Name 
FROM
 casting c
JOIN actor a ON
c.actorid = a.id
Where movieid IN
(SELECT id FROM movie WHERE title = 'Alien');

gideondsouza

SELECT m.title
FROM 
 movie m
JOIN casting c ON
 m.id = c.movieid
WHERE c.actorid IN
(Select id FROM actor WHERE name='Harrison Ford');

gideondsouza

SELECT m.title
FROM 
 movie m
JOIN casting c ON
 m.id = c.movieid AND 
 c.ord <> 1
WHERE c.actorid IN
(Select id FROM actor WHERE name='Harrison Ford')

gideondsouza

SELECT m.title,a.name
 FROM casting c JOIN movie m ON
   m.id = c.movieid
 JOIN actor a ON 
   a.id = c.actorid  AND
   c.ord = 1
WHERE m.yr = 1962

gideondsouza

SELECT yr,COUNT(title) FROM
  movie JOIN casting ON movie.id=movieid
         JOIN actor   ON actorid=actor.id
WHERE name='John Travolta'
GROUP BY yr  
HAVING COUNT(title)=(SELECT MAX(c) FROM
(SELECT yr,COUNT(title) AS c FROM
   movie JOIN casting ON movie.id=movieid
         JOIN actor   ON actorid=actor.id
 WHERE name='John Travolta'

gideondsouza

SELECT m.title, a.name
  FROM casting c JOIN movie m ON
   m.id = c.movieid AND
   c.ord = 1
 JOIN actor a ON 
   a.id = c.actorid
WHERE m.id IN (
 SELECT m.id
  FROM casting c JOIN movie m ON
    m.id = c.movieid