sqlzoo练习答案--More JOIN operations
来源:互联网 发布:一元云购源码后台登录 编辑:程序博客网 时间:2024/05/17 09:35
Movie Database
This tutorial introduces the notion of a join. The database consists of three tables movie
, actor
and casting
.
1、List the films where the yr is 1962 [Show id, title]
2、Give year of '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.
4、What are the titles of the films with id 11768, 11955, 21191
5、What id number does the actress 'Glenn Close' have?
6、What is the id of the film 'Casablanca'
7、
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, this is the value that you obtained in the previous question.
8、Obtain the cast list for the film 'Alien'
9、List the films in which 'Harrison Ford' has appeared
10、List the films where 'Harrison Ford' has appeared - but not in the starring role. [Note: the ord field of casting gives the position of the actor. If ord=1 then this actor is in the starring role]
11、List the films together with the leading star for all 1962 films.
12、Which were the busiest years for 'John Travolta', show the year and the number of movies he made each year for any year in which he made more than 2 movies.
13、List the film title and the leading actor for all of the films 'Julie Andrews' played in.
14、Obtain a list, in alphabetical order, of actors who've had at least 30 starring roles.
15、List the films released in the year 1978 ordered by the number of actors in the cast.
16、List all the people who have worked with 'Art Garfunkel'.
原文链接 http://blog.csdn.net/crazy__chen/article/details/50514100
阅读全文
0 0
- sqlzoo练习答案--More JOIN operations
- sqlzoo练习答案--More JOIN operations
- SQLZOO(More JOIN operations)Writeup
- sqlzoo练习答案--Self join
- sqlzoo练习答案--Self join
- sqlzoo练习答案--The JOIN operation
- sqlzoo练习答案--The JOIN operation
- SQLZOO MORE JOIN OPERATION
- SQLZOO 练习答案 SELECT_basic_names
- sqlzoo练习答案--Using Null
- sqlzoo练习答案--Using Null
- sqlzoo练习答案--SELECT basics/zh
- sqlzoo练习答案--SELECT names/zh
- sqlzoo练习答案--SELECT within SELECT Tutorial
- sqlzoo练习答案--SUM and COUNT
- SQLZOO 练习答案 SELECT FROM world
- sqlzoo练习答案--SELECT names/zh
- sqlzoo练习答案--SELECT basics/zh
- 使用报表工具FastReport.NET在XAML中创建表格
- MySQL-创建、修改和删除表
- 旗正规则引擎规则编辑指南
- 在ubuntu14.04中安装Hammerora-2.10——测试mysql、oracle性能够的工具
- GTK学习(4)-主循环(main loop)的工作原理
- sqlzoo练习答案--More JOIN operations
- 7614_最低通行费
- Python 学习笔记 多进程 multiprocessing
- C++ 浮点型四舍五入
- eclipse中使用git命令行操作的配置方法
- 用JavaScript调用.exe文件 兼容浏览器
- Zookeeper的安装配置和简单使用-yellowcong
- Python 模块
- python 爬虫入门(5) url异常处理 ; cookie使用 ;cookielib