sqlzoo - More JOIN operations/zh 答案

SELECT id, title
FROM movie
WHERE yr=1962

SELECT yr
FROM movie
WHERE title LIKE 'Citizen Kane%' 

SELECT id, title, yr
FROM movie
WHERE title LIKE 'Star Trek%' 

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

SELECT id
FROM actor
WHERE name LIKE 'Glenn Close'

SELECT id
FROM movie
WHERE title LIKE 'Casablanca'

SELECT name 
FROM actor
WHERE id IN (
  SELECT actorid
  FROM movie m JOIN casting c ON m.id = c.movieid
  WHERE id = 11768)

SELECT name 
FROM actor
WHERE id IN (
  SELECT actorid
  FROM movie m JOIN casting c ON m.id = c.movieid
  WHERE id = (
    SELECT id
    FROM movie
    WHERE title LIKE 'Alien'))

<