SQLZOO答案6:More_JOIN_operations/zh

• /More_JOIN_operations/zh

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 title from movie where id in(11768, 11955, 21191 )

select id from actor where  name='Glenn Close'

select id from movie where title='Casablanca'

select a.name from actor as a join casting as b on a.id=b.actorid where b.movieid=11768

select a.name from actor as a join casting as b on a.id=b.actorid where b.movieid in (select id from movie where title='Alien')```

9.
```sql
select title from movie join casting on movie.id=casting.movieid join  actor on casting.actorid=actor.id  where actor.name='Harrison Ford' 

select title from movie join casting on movie.id=casting.movieid join  actor on casting.actorid=actor.id  where actor.name='Harrison Ford' and casting.ord<>1

select title,name from movie join casting on yr=1962 and ord=1 join actor on movie.id=casting.movieid and actor.id=casting.actorid 

• Harder