Difference between revisions of "JOIN Quiz 2"

From SQLZOO
Jump to: navigation, search
Line 1: Line 1:
 
JOIN Quiz - part 2
 
JOIN Quiz - part 2
  
<quiz shuffle=none display=simple>
+
<div class=quiz>
{Select the statement which lists the unfortunate directors of the movies which have caused financial loses (gross <  budget)
+
<div class=q>Select the statement which lists the unfortunate directors of the movies which have caused financial loses (gross <  budget)
|type="()"}
+
<syntaxhighlight class=d lang='sql'> SELECT JOIN(name FROM actor, movie ON actor.id:director WHERE gross < budget) GROUP BY name </syntaxhighlight>
- <syntaxhighlight lang='sql'> SELECT JOIN(name FROM actor, movie ON actor.id:director WHERE gross < budget) GROUP BY name </syntaxhighlight>
+
<syntaxhighlight class=d lang='sql'> SELECT name FROM actor INNER JOIN movie BY actor.id = director HAVING gross < budget </syntaxhighlight>
- <syntaxhighlight lang='sql'> SELECT name FROM actor INNER JOIN movie BY actor.id = director HAVING gross < budget </syntaxhighlight>
+
<syntaxhighlight class='d y' lang='sql'> SELECT name FROM actor INNER JOIN movie ON actor.id = director WHERE gross < budget </syntaxhighlight>
+ <syntaxhighlight lang='sql'> SELECT name FROM actor INNER JOIN movie ON actor.id = director WHERE gross < budget </syntaxhighlight>
+
<syntaxhighlight class=d lang='sql'> SELECT name FROM actor INNER JOIN movie ON actor.id:director WHERE gross < budget </syntaxhighlight>
- <syntaxhighlight lang='sql'> SELECT name FROM actor INNER JOIN movie ON actor.id:director WHERE gross < budget </syntaxhighlight>
+
<syntaxhighlight class=d lang='sql'> SELECT name FROM director INNER JOIN movie ON movie.id = director.id WHERE gross < budget </syntaxhighlight>
- <syntaxhighlight lang='sql'> SELECT name FROM director INNER JOIN movie ON movie.id = director.id WHERE gross < budget </syntaxhighlight>
+
</div>
  
{Select the correct example of JOINing three tables
+
<div class=q>Select the correct example of JOINing three tables
|type="()"}
+
<syntaxhighlight class=d lang='sql'> SELECT * FROM actor JOIN casting BY actor.id = actorid JOIN movie BY movie.id = movieid </syntaxhighlight>
- <syntaxhighlight lang='sql'> SELECT * FROM actor JOIN casting BY actor.id = actorid JOIN movie BY movie.id = movieid </syntaxhighlight>
+
<syntaxhighlight class=d lang='sql'> SELECT * FROM actor JOIN casting ON actor.id = actorid AND JOIN movie ON movie.id = movieid </syntaxhighlight>
- <syntaxhighlight lang='sql'> SELECT * FROM actor JOIN casting ON actor.id = actorid AND JOIN movie ON movie.id = movieid </syntaxhighlight>
+
<syntaxhighlight class=d lang='sql'> SELECT * FROM actor JOIN casting JOIN movie ON actor.id = actorid AND movie.id = movieid </syntaxhighlight>
- <syntaxhighlight lang='sql'> SELECT * FROM actor JOIN casting JOIN movie ON actor.id = actorid AND movie.id = movieid </syntaxhighlight>
+
<syntaxhighlight class=d lang='sql'> SELECT * FROM actor JOIN casting ON actor.id = actorid AND movie ON movie.id = movieid </syntaxhighlight>
- <syntaxhighlight lang='sql'> SELECT * FROM actor JOIN casting ON actor.id = actorid AND movie ON movie.id = movieid </syntaxhighlight>
+
<syntaxhighlight class='d y' lang='sql'> SELECT * FROM actor JOIN casting ON actor.id = actorid JOIN movie ON movie.id = movieid </syntaxhighlight>
+ <syntaxhighlight lang='sql'> SELECT * FROM actor JOIN casting ON actor.id = actorid JOIN movie ON movie.id = movieid </syntaxhighlight>
+
</div>
  
{Select the statement that shows the list of actors called 'John' by order of number of movies in which they acted
+
<div class=q>Select the statement that shows the list of actors called 'John' by order of number of movies in which they acted
|type="()"}
+
<syntaxhighlight class=d lang='sql'> SELECT name, COUNT(movieid) FROM actor JOIN casting ON actorid=actor.id WHERE name IN 'John %' GROUP BY name ORDER BY 2 </syntaxhighlight>
- <syntaxhighlight lang='sql'> SELECT name, COUNT(movieid) FROM actor JOIN casting ON actorid=actor.id WHERE name IN 'John %' GROUP BY name ORDER BY 2 </syntaxhighlight>
+
<syntaxhighlight class=d lang='sql'> SELECT name, COUNT(movieid) FROM actor JOIN casting ON actorid=actor.id WHERE name LIKE 'J%' GROUP BY name ORDER BY 2 DESC </syntaxhighlight>
- <syntaxhighlight lang='sql'> SELECT name, COUNT(movieid) FROM actor JOIN casting ON actorid=actor.id WHERE name LIKE 'J%' GROUP BY name ORDER BY 2 DESC </syntaxhighlight>
+
<syntaxhighlight class='d y' lang='sql'> SELECT name, COUNT(movieid) FROM casting JOIN actor ON actorid=actor.id WHERE name LIKE 'John %' GROUP BY name ORDER BY 2 DESC </syntaxhighlight>
+ <syntaxhighlight lang='sql'> SELECT name, COUNT(movieid) FROM casting JOIN actor ON actorid=actor.id WHERE name LIKE 'John %' GROUP BY name ORDER BY 2 DESC </syntaxhighlight>
+
<syntaxhighlight class=d lang='sql'> SELECT name, COUNT(movieid) FROM casting JOIN actor WHERE (actorid ON actor.id) AND name LIKE 'John %' GROUP BY name ORDER BY 2 DESC </syntaxhighlight>
- <syntaxhighlight lang='sql'> SELECT name, COUNT(movieid) FROM casting JOIN actor WHERE (actorid ON actor.id) AND name LIKE 'John %' GROUP BY name ORDER BY 2 DESC </syntaxhighlight>
+
<syntaxhighlight class=d lang='sql'> SELECT name, COUNT(movieid) FROM casting JOIN actor WHERE name LIKE 'John %' GROUP BY name ORDER BY COUNT(movieid) DESC </syntaxhighlight>
- <syntaxhighlight lang='sql'> SELECT name, COUNT(movieid) FROM casting JOIN actor WHERE name LIKE 'John %' GROUP BY name ORDER BY COUNT(movieid) DESC </syntaxhighlight>
+
</div>
  
{Select the result that would be obtained from the following code:  
+
<div class=q>Select the result that would be obtained from the following code:  
 
<syntaxhighlight lang='sql'>
 
<syntaxhighlight lang='sql'>
 
  SELECT title  
 
  SELECT title  
Line 32: Line 32:
 
   WHERE name='Paul Hogan' AND movieid=movie.id AND actorid=actor.id AND ord = 1
 
   WHERE name='Paul Hogan' AND movieid=movie.id AND actorid=actor.id AND ord = 1
 
</syntaxhighlight>
 
</syntaxhighlight>
<table style='float:left'><caption>Table-A</caption><tr><td>"Crocodile" Dundee</td><td>1</td></tr><tr><td>Crocodile Dundee in Los Angeles</td><td>1</td></tr><tr><td>Flipper</td><td>1</td></tr><tr><td>Lightning Jack</td><td>1</td></tr></table>
+
<table class=d><caption>Table-A</caption><tr><td>"Crocodile" Dundee</td><td>1</td></tr><tr><td>Crocodile Dundee in Los Angeles</td><td>1</td></tr><tr><td>Flipper</td><td>1</td></tr><tr><td>Lightning Jack</td><td>1</td></tr></table>
<table style='float:left'><caption>Table-B</caption><tr><td>"Crocodile" Dundee</td></tr><tr><td>Crocodile Dundee in Los Angeles</td></tr><tr><td>Flipper</td></tr><tr><td>Lightning Jack</td></tr></table>
+
<table class='d y'><caption>Table-B</caption><tr><td>"Crocodile" Dundee</td></tr><tr><td>Crocodile Dundee in Los Angeles</td></tr><tr><td>Flipper</td></tr><tr><td>Lightning Jack</td></tr></table>
<table style='float:left'><caption>Table-C</caption><tr><td>"Crocodile" Dundee</td></tr><tr><td>Paul Hogan</td></tr><tr><td>1</td></tr></table>
+
<table class=d><caption>Table-C</caption><tr><td>"Crocodile" Dundee</td></tr><tr><td>Paul Hogan</td></tr><tr><td>1</td></tr></table>
<table style='float:left'><caption>Table-D</caption><tr><td>"Crocodile" Dundee</td><td>Paul Hogan</td><td>1</td></tr><tr><td>Crocodile Dundee in Los Angeles</td><td>Paul Hogan</td><td>1</td></tr><tr><td>Flipper</td><td>Paul Hogan</td><td>1</td></tr><tr><td>Lightning Jack</td><td>Paul Hogan</td><td>1</td></tr></table>
+
<table class=d><caption>Table-D</caption><tr><td>"Crocodile" Dundee</td><td>Paul Hogan</td><td>1</td></tr><tr><td>Crocodile Dundee in Los Angeles</td><td>Paul Hogan</td><td>1</td></tr><tr><td>Flipper</td><td>Paul Hogan</td><td>1</td></tr><tr><td>Lightning Jack</td><td>Paul Hogan</td><td>1</td></tr></table>
<table style='float:left'><caption>Table-E</caption><tr><td>"Crocodile" Dundee</td><td>Paul Hogan</td></tr><tr><td>Crocodile Dundee in Los Angeles</td><td>Paul Hogan</td></tr><tr><td>Flipper</td><td>Paul Hogan</td></tr><tr><td>Lightning Jack</td><td>Paul Hogan</td></tr></table>
+
<table class=d><caption>Table-E</caption><tr><td>"Crocodile" Dundee</td><td>Paul Hogan</td></tr><tr><td>Crocodile Dundee in Los Angeles</td><td>Paul Hogan</td></tr><tr><td>Flipper</td><td>Paul Hogan</td></tr><tr><td>Lightning Jack</td><td>Paul Hogan</td></tr></table>
|type="()"}
+
</div>
- Table-A
 
+ Table-B
 
- Table-C
 
- Table-D
 
- Table-E
 
  
{Select the statement that lists all the actors that starred in movies directed by Ridley Scott
+
<div class=q>Select the statement that lists all the actors that starred in movies directed by Ridley Scott
|type="()"}
+
<syntaxhighlight class=d lang='sql'> SELECT name FROM movie JOIN casting AND actor ON movie.id = movieid AND actor.id = actorid WHERE ord = NULL AND director = (SELECT id FROM actor WHERE name LIKE 'Ridley Scott') </syntaxhighlight>
- <syntaxhighlight lang='sql'> SELECT name FROM movie JOIN casting AND actor ON movie.id = movieid AND actor.id = actorid WHERE ord = NULL AND director = (SELECT id FROM actor WHERE name LIKE 'Ridley Scott') </syntaxhighlight>
+
<syntaxhighlight class=d lang='sql'> SELECT name FROM movie JOIN casting JOIN actor ON movie.id = movieid OR actor.id = actorid WHERE ord = 1 AND director = (SELECT id FROM actor WHERE name LIKE 'Ridley Scott') </syntaxhighlight>
- <syntaxhighlight lang='sql'> SELECT name FROM movie JOIN casting JOIN actor ON movie.id = movieid OR actor.id = actorid WHERE ord = 1 AND director = (SELECT id FROM actor WHERE name LIKE 'Ridley Scott') </syntaxhighlight>
+
<syntaxhighlight class=d lang='sql'> SELECT name FROM movie JOIN casting ON movie.id = movieid JOIN actor ON actor.id = actorid WHERE ord = 1 AND actorid = (SELECT id FROM actor WHERE name LIKE 'Ridley Scott') </syntaxhighlight>
- <syntaxhighlight lang='sql'> SELECT name FROM movie JOIN casting ON movie.id = movieid JOIN actor ON actor.id = actorid WHERE ord = 1 AND actorid = (SELECT id FROM actor WHERE name LIKE 'Ridley Scott') </syntaxhighlight>
+
<syntaxhighlight class='d y' lang='sql'> SELECT name FROM movie JOIN casting ON movie.id = movieid JOIN actor ON actor.id = actorid WHERE ord = 1 AND director = (SELECT id FROM actor WHERE name LIKE 'Ridley Scott') </syntaxhighlight>
+ <syntaxhighlight lang='sql'> SELECT name FROM movie JOIN casting ON movie.id = movieid JOIN actor ON actor.id = actorid WHERE ord = 1 AND director = (SELECT id FROM actor WHERE name LIKE 'Ridley Scott') </syntaxhighlight>
+
<syntaxhighlight class=d lang='sql'> SELECT name FROM movie JOIN casting ON movie.id = actorid JOIN actor ON actor.id = movieid WHERE director = (SELECT id FROM actor WHERE name LIKE 'Ridley Scott') </syntaxhighlight>
- <syntaxhighlight lang='sql'> SELECT name FROM movie JOIN casting ON movie.id = actorid JOIN actor ON actor.id = movieid WHERE director = (SELECT id FROM actor WHERE name LIKE 'Ridley Scott') </syntaxhighlight>
+
</div>
  
{Select the statement showing all movies with budget bigger than ALL movie with Harrison Ford is '''incorrect'''
+
<div class=q>Select the statement showing all movies with budget bigger than ALL movie with Harrison Ford is '''incorrect'''
|type="()"}
+
<syntaxhighlight class=d lang='sql'> SELECT title FROM movie WHERE budget > ALL (SELECT budget FROM movie JOIN casting JOIN actor ON movie.id = movieid AND actor.id = actorid WHERE name = 'Harrison Ford')</syntaxhighlight>
- <syntaxhighlight lang='sql'> SELECT title FROM movie WHERE budget > ALL (SELECT budget FROM movie JOIN casting JOIN actor ON movie.id = movieid AND actor.id = actorid WHERE name = 'Harrison Ford')</syntaxhighlight>
+
<syntaxhighlight class='d y' lang='sql'> SELECT title FROM movie WHERE budget > ALL (SELECT budget FROM movie JOIN casting JOIN actor ON movie.id = movieid AND actor.id = actorid OR name = 'Harrison Ford')</syntaxhighlight>
+ <syntaxhighlight lang='sql'> SELECT title FROM movie WHERE budget > ALL (SELECT budget FROM movie JOIN casting JOIN actor ON movie.id = movieid AND actor.id = actorid OR name = 'Harrison Ford')</syntaxhighlight>
+
<syntaxhighlight class=d lang='sql'> SELECT title FROM movie WHERE budget > (SELECT MAX(budget) FROM movie JOIN casting JOIN actor ON movie.id = movieid AND actor.id = actorid WHERE name = 'Harrison Ford')</syntaxhighlight>
- <syntaxhighlight lang='sql'> SELECT title FROM movie WHERE budget > (SELECT MAX(budget) FROM movie JOIN casting JOIN actor ON movie.id = movieid AND actor.id = actorid WHERE name = 'Harrison Ford')</syntaxhighlight>
+
<syntaxhighlight class=d lang='sql'> SELECT title FROM movie WHERE budget > ALL (SELECT budget FROM movie JOIN casting ON movie.id = movieid JOIN actor ON actor.id = actorid WHERE name = 'Harrison Ford')</syntaxhighlight>
- <syntaxhighlight lang='sql'> SELECT title FROM movie WHERE budget > ALL (SELECT budget FROM movie JOIN casting ON movie.id = movieid JOIN actor ON actor.id = actorid WHERE name = 'Harrison Ford')</syntaxhighlight>
+
<syntaxhighlight class=d lang='sql'> SELECT title FROM movie WHERE budget > (SELECT MAX(budget) FROM movie JOIN casting JOIN actor ON movie.id = movieid AND actor.id = actorid AND name = 'Harrison Ford')</syntaxhighlight>
- <syntaxhighlight lang='sql'> SELECT title FROM movie WHERE budget > (SELECT MAX(budget) FROM movie JOIN casting JOIN actor ON movie.id = movieid AND actor.id = actorid AND name = 'Harrison Ford')</syntaxhighlight>
+
</div>
  
{Select the result that would be obtained from the following code:  
+
<div class=q>Select the result that would be obtained from the following code:  
 
<syntaxhighlight lang='sql'>
 
<syntaxhighlight lang='sql'>
 
  SELECT title, yr  
 
  SELECT title, yr  
Line 66: Line 61:
 
   WHERE name='Robert De Niro' AND movieid=movie.id AND actorid=actor.id AND ord = 3
 
   WHERE name='Robert De Niro' AND movieid=movie.id AND actorid=actor.id AND ord = 3
 
</syntaxhighlight>
 
</syntaxhighlight>
<table style='float:left'><caption>Table-A</caption><tr><td>A Bronx Tale</td><td>1993</td><td>3</td></tr><tr><td>Bang the Drum Slowly</td><td>1973</td><td>3</td></tr><tr><td>Limitless</td><td>2011</td><td>3</td></tr></table>
+
<table class=d><caption>Table-A</caption><tr><td>A Bronx Tale</td><td>1993</td><td>3</td></tr><tr><td>Bang the Drum Slowly</td><td>1973</td><td>3</td></tr><tr><td>Limitless</td><td>2011</td><td>3</td></tr></table>
<table style='float:left'><caption>Table-B</caption><tr><td>A Bronx Tale</td><td>1993</td></tr><tr><td>Bang the Drum Slowly</td><td>1973</td></tr><tr><td>Limitless</td><td>2011</td></tr></table>
+
<table class='d y'><caption>Table-B</caption><tr><td>A Bronx Tale</td><td>1993</td></tr><tr><td>Bang the Drum Slowly</td><td>1973</td></tr><tr><td>Limitless</td><td>2011</td></tr></table>
<table style='float:left'><caption>Table-C</caption><tr><td>A Bronx Tale</td><td>3</td></tr><tr><td>Bang the Drum Slowly</td><td>3</td></tr><tr><td>Limitless</td><td>3</td></tr></table>
+
<table class=d><caption>Table-C</caption><tr><td>A Bronx Tale</td><td>3</td></tr><tr><td>Bang the Drum Slowly</td><td>3</td></tr><tr><td>Limitless</td><td>3</td></tr></table>
<table style='float:left'><caption>Table-D</caption><tr><td>A Bronx Tale</td></tr><tr><td>Bang the Drum Slowly</td></tr><tr><td>Limitless</td></tr></table>
+
<table class=d><caption>Table-D</caption><tr><td>A Bronx Tale</td></tr><tr><td>Bang the Drum Slowly</td></tr><tr><td>Limitless</td></tr></table>
<table style='float:left'><caption>Table-E</caption><tr><td>A Bronx Tale</td><td>Robert De Niro</td><td>1993</td></tr><tr><td>Bang the Drum Slowly</td><td>Robert De Niro</td><td>1973</td></tr><tr><td>Limitless</td><td>Robert De Niro</td><td>2011</td></tr></table>
+
<table class=d><caption>Table-E</caption><tr><td>A Bronx Tale</td><td>Robert De Niro</td><td>1993</td></tr><tr><td>Bang the Drum Slowly</td><td>Robert De Niro</td><td>1973</td></tr><tr><td>Limitless</td><td>Robert De Niro</td><td>2011</td></tr></table>
|type="()"}
+
</div>
- Table-A
 
+ Table-B
 
- Table-C
 
- Table-D
 
- Table-E
 
 
 
</quiz>
 
  
 
[[Category:Quizzes]]
 
[[Category:Quizzes]]

Revision as of 22:17, 22 April 2015

JOIN Quiz - part 2

Select the statement which 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
Select the correct example of JOINing three tables
 SELECT * FROM actor JOIN casting BY actor.id = actorid JOIN movie BY movie.id = movieid
 SELECT * FROM actor JOIN casting ON actor.id = actorid AND JOIN movie ON movie.id = movieid
 SELECT * FROM actor JOIN casting JOIN movie ON actor.id = actorid AND movie.id = movieid
 SELECT * FROM actor JOIN casting ON actor.id = actorid AND movie ON movie.id = movieid
 SELECT * FROM actor JOIN casting ON actor.id = actorid JOIN movie ON movie.id = movieid
Select the statement that shows the list of actors called 'John' by order of number of movies in which they acted
 SELECT name, COUNT(movieid) FROM actor JOIN casting ON actorid=actor.id WHERE name IN 'John %' GROUP BY name ORDER BY 2
 SELECT name, COUNT(movieid) FROM actor JOIN casting ON actorid=actor.id WHERE name LIKE 'J%' GROUP BY name ORDER BY 2 DESC
 SELECT name, COUNT(movieid) FROM casting JOIN actor ON actorid=actor.id WHERE name LIKE 'John %' GROUP BY name ORDER BY 2 DESC
 SELECT name, COUNT(movieid) FROM casting JOIN actor WHERE (actorid ON actor.id) AND name LIKE 'John %' GROUP BY name ORDER BY 2 DESC
 SELECT name, COUNT(movieid) FROM casting JOIN actor WHERE name LIKE 'John %' GROUP BY name ORDER BY COUNT(movieid) DESC
Select the result that would be obtained from the following code:
 SELECT title 
   FROM movie, casting, actor 
  WHERE name='Paul Hogan' AND movieid=movie.id AND actorid=actor.id AND ord = 1
Table-A
"Crocodile" Dundee1
Crocodile Dundee in Los Angeles1
Flipper1
Lightning Jack1
Table-B
"Crocodile" Dundee
Crocodile Dundee in Los Angeles
Flipper
Lightning Jack
Table-C
"Crocodile" Dundee
Paul Hogan
1
Table-D
"Crocodile" DundeePaul Hogan1
Crocodile Dundee in Los AngelesPaul Hogan1
FlipperPaul Hogan1
Lightning JackPaul Hogan1
Table-E
"Crocodile" DundeePaul Hogan
Crocodile Dundee in Los AngelesPaul Hogan
FlipperPaul Hogan
Lightning JackPaul Hogan
Select the statement that lists all the actors that starred in movies directed by Ridley Scott
 SELECT name FROM movie JOIN casting AND actor ON movie.id = movieid AND actor.id = actorid WHERE ord = NULL AND director = (SELECT id FROM actor WHERE name LIKE 'Ridley Scott')
 SELECT name FROM movie JOIN casting JOIN actor ON movie.id = movieid OR actor.id = actorid WHERE ord = 1 AND director = (SELECT id FROM actor WHERE name LIKE 'Ridley Scott')
 SELECT name FROM movie JOIN casting ON movie.id = movieid JOIN actor ON actor.id = actorid WHERE ord = 1 AND actorid = (SELECT id FROM actor WHERE name LIKE 'Ridley Scott')
 SELECT name FROM movie JOIN casting ON movie.id = movieid JOIN actor ON actor.id = actorid WHERE ord = 1 AND director = (SELECT id FROM actor WHERE name LIKE 'Ridley Scott')
 SELECT name FROM movie JOIN casting ON movie.id = actorid JOIN actor ON actor.id = movieid WHERE director = (SELECT id FROM actor WHERE name LIKE 'Ridley Scott')
Select the statement showing all movies with budget bigger than ALL movie with Harrison Ford is incorrect
 SELECT title FROM movie WHERE budget > ALL (SELECT budget FROM movie JOIN casting JOIN actor ON movie.id = movieid AND actor.id = actorid WHERE name = 'Harrison Ford')
 SELECT title FROM movie WHERE budget > ALL (SELECT budget FROM movie JOIN casting JOIN actor ON movie.id = movieid AND actor.id = actorid OR name = 'Harrison Ford')
 SELECT title FROM movie WHERE budget > (SELECT MAX(budget) FROM movie JOIN casting JOIN actor ON movie.id = movieid AND actor.id = actorid WHERE name = 'Harrison Ford')
 SELECT title FROM movie WHERE budget > ALL (SELECT budget FROM movie JOIN casting ON movie.id = movieid JOIN actor ON actor.id = actorid WHERE name = 'Harrison Ford')
 SELECT title FROM movie WHERE budget > (SELECT MAX(budget) FROM movie JOIN casting JOIN actor ON movie.id = movieid AND actor.id = actorid AND name = 'Harrison Ford')
Select the result that would be obtained from the following code:
 SELECT title, yr 
   FROM movie, casting, actor 
  WHERE name='Robert De Niro' AND movieid=movie.id AND actorid=actor.id AND ord = 3
Table-A
A Bronx Tale19933
Bang the Drum Slowly19733
Limitless20113
Table-B
A Bronx Tale1993
Bang the Drum Slowly1973
Limitless2011
Table-C
A Bronx Tale3
Bang the Drum Slowly3
Limitless3
Table-D
A Bronx Tale
Bang the Drum Slowly
Limitless
Table-E
A Bronx TaleRobert De Niro1993
Bang the Drum SlowlyRobert De Niro1973
LimitlessRobert De Niro2011