SQLZOO:More JOIN operations

UnbreakableLim

于 2020-06-20 17:01:56 发布

阅读量249

点赞数 1

CC 4.0 BY-SA版权

分类专栏：练习 SQLZOO 文章标签： mysql

本文链接：https://blog.youkuaiyun.com/UnbreakableLim/article/details/106871607

本文通过一系列SQL查询示例，详细解释了如何在SQLZOO平台上进行更复杂的JOIN操作，包括查询电影年份、列出特定主题电影、获取演员ID、查找电影ID、获取电影演员列表等。内容涵盖了从基本的电影信息查询到复杂的演员与电影关联的查询，旨在提升SQL查询技能。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

2.Give year of ‘Citizen Kane’.

select yr
FROM movie
WHERE title='Citizen Kane';

3.List all of the Star Trek movies, include the id, title and yr (all of these movies include the words Star Trek in the title). Order results by year.

select id,title,yr
from movie
where title like '%Star Trek%'
order by yr;

4.What id number does the actor ‘Glenn Close’ have?

select id
from actor
where name='Glenn Close';

5.What is the id of the film ‘Casablanca’

select id
from movie
where title='Casablanca';

6.Obtain the cast list for ‘Casablanca’.

what is a cast list?
The cast list is the names of the actors who were in the movie.
Use movieid=11768, (or whatever value you got from the previous question)

select name
from actor join (movie join casting on id=movieid) 
		   on actor.id=actorid
where title='Casablanca';

7.Obtain the cast

最低0.47元/天解锁文章