Difference between revisions of "JOIN Quiz 2"

From SQLZOO
Jump to: navigation, search
Line 116: Line 116:
 
{Which of the following statements lists the unfortunate directors of the movies which have caused financial loses? (gross <  budget)
 
{Which of the following statements lists the unfortunate directors of the movies which have caused financial loses? (gross <  budget)
 
|type="()"}
 
|type="()"}
 +
- SELECT JOIN(name FROM actor, movie ON actor.id:director WHERE gross < budget) GROUP BY name
 +
- SELECT name FROM actor INNER JOIN movie BY actor.id = director HAVING gross < budget
 
+ SELECT name FROM actor INNER JOIN movie ON actor.id = director WHERE gross < budget  
 
+ SELECT name FROM actor INNER JOIN movie ON actor.id = director WHERE gross < budget  
 
- SELECT name FROM actor INNER JOIN movie ON actor.id:director WHERE gross < budget  
 
- SELECT name FROM actor INNER JOIN movie ON actor.id:director WHERE gross < budget  
- SELECT JOIN(name FROM actor, movie ON actor.id:director WHERE gross < budget) GROUP BY name
 
 
- SELECT name FROM director INNER JOIN movie ON movie.id = director.id WHERE gross < budget  
 
- SELECT name FROM director INNER JOIN movie ON movie.id = director.id WHERE gross < budget  
- SELECT name FROM actor INNER JOIN movie BY actor.id = director HAVING gross < budget
 
  
 
</quiz>
 
</quiz>
  
 
[[Category:Quizzes]]
 
[[Category:Quizzes]]

Revision as of 15:12, 18 July 2012

JOIN Quiz - part 2

movie
Field name Type Notes
id INTEGER An arbitrary unique identifier
title CHAR(70) The name of the film - usually in the language of the first release.
yr DECIMAL(4) Year of first release.
director INT A reference to the actor table.
budget INTEGER How much the movie cost to make (in a variety of currencies unfortunately).
gross INTEGER How much the movie made at the box office.
actor
Field name Type Notes
id INTEGER An arbitrary unique identifier
name CHAR(36) The name of the actor (the term actor is used to refer to both male and female thesps.)
casting
Field name Type Notes
movieid INTEGER A reference to the movie table.
actorid INTEGER A reference to the actor table.
ord INTEGER The ordinal position of the actor in the cast list. The

star of the movie will have ord value 1 the co-star will have

value 2, ...

1. Which of the following statements lists the unfortunate directors of the movies which have caused financial loses? (gross < budget)

SELECT JOIN(name FROM actor, movie ON actor.id:director WHERE gross < budget) GROUP BY name
SELECT name FROM actor INNER JOIN movie BY actor.id = director HAVING gross < budget
SELECT name FROM actor INNER JOIN movie ON actor.id = director WHERE gross < budget
SELECT name FROM actor INNER JOIN movie ON actor.id:director WHERE gross < budget
SELECT name FROM director INNER JOIN movie ON movie.id = director.id WHERE gross < budget

Your score is 0 / 0
Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense