<<< Directors who plays in their movies >>>
Scenario Movies
b2b9231b6443a0aa5631c90be81fc38491833122132db85f5699b268df22e189
See details on the model
In this scenario, we have three tables representing movies and the actors appearing in movies.
The table person contains the list of people who are actors or directors in movies; this table has 2 attributes:
- id a unique identifier for this person
- name the name of that person
The table movie that has 6 attributes:
- id a unique identifier for the movie
- title the name of the movie
- yr the year the movie was released
- director an integer (referring to the id of someone in the person table)
- budget the budget of the movie (in dollars)
- gross the amount of money generated by the movie (in dollars)
The table casting describes which actor playing in which movie and has 3 attributes:
- actorid, an integer referring to a person (who played in the movie)
- movieid, an integer referring to a movie (in which movie the actor played in)
- ord, an integer that describes the importance of the character the actor plays in the movie (1 means main character, 2 is the second role, etc.).
Question
Directors who plays in their movies
{"rows":[["Adam McKay"],["Adam Shankman"],["Adrienne Shelly"],["Akiva Schaffer"],["Alejandro Agresti"],["Alex Kendrick"],["Amber Benson"],["Andrew Adamson"],["Arliss Howard"],["Barry Bowles"],["Barry Sonnenfeld"],["Ben Stiller"],["Bill Paxton"],["Bob Odenkirk"],["Bobcat Goldthwait"],["Bonnie Hunt"],["Brad Bird"],["Britt Allcroft"],["Bruce McCulloch"],["Carlos Saldanha"],["Charles S. Dutton"],["Chris Columbus"],["Chris Rock"],["Christian Taylor"],["Christopher Guest"],["Clark Johnson"],["Clayton Jacobson"],["Clint Eastwood"],["Conrad Vernon"],["Cory McAbee"],["DJ Pooh"],["Danny DeVito"],["Darren Aronofsky"],["David Bowers"],["David Wain"],["David Wall"],["Dennis Dugan"],["Denzel Washington"],["Diane Keaton"],["Drew Barrymore"],["Ed Harris"],["Edgar Wright"],["Edward Norton"],["Eli Roth"],["Elia Suleiman"],["Emilio Estevez"],["Francis Ford Coppola"],["Frank Coraci"],["Frank Miller"],["Frank Whaley"],["Garth Jennings"],["George Clooney"],["Greg McLean"],["Harold Ramis"],["Harry Elfont"],["Henry Bean"],["Jake Rademacher"],["Jay Chandrasekhar"],["Jeffrey Lau"],["Jennifer Jason Leigh"],["Jiang Wen"],["Jimmy Wang"],["John Cameron Mitchell"],["John Krasinski"],["John Waters"],["Jon Favreau"],["Kevin Costner"],["Kevin Smith"],["Kurt Wimmer"],["Louie Psihoyos"],["Luke Greenfield"],["Lynn Shelton"],["M. Night Shyamalan"],["Mark Dindal"],["Martin Scorsese"],["Matt Dillon"],["Matt Maiellaro"],["Michael Keaton"],["Michael Moore"],["Mike Binder"],["Mike Judge"],["Mike Nawrocki"],["Nanni Moretti"],["Nia Vardalos"],["Nikita Mikhalkov"],["Nisha Ganatra"],["Noel Clarke"],["Oliver Stone"],["Pete Docter"],["Peter Berg"],["Peter Howitt"],["Rakesh Roshan"],["Richard Benjamin"],["Rob Reiner"],["Rob Zombie"],["Robert Redford"],["Roberto Benigni"],["Shawn Levy"],["Stacy Peralta"],["Stephen Chow"],["Steve Anderson"],["Steve Buscemi"],["Steve Oedekerk"],["Steven Brill"],["Stuart Baird"],["Sydney Pollack"],["Sylvester Stallone"],["Todd Phillips"],["Tom Green"],["Tom McGrath"],["Tommy Wiseau"],["Tony Jaa"],["Trevor Moore"],["Trey Parker"],["Tyler Perry"],["Vanessa Parise"],["Walt Becker"],["Wes Anderson"],["Wes Craven"],["William Shatner"],["Woody Allen"],["Zach Braff"]],"fields":[{"name":"name","dataTypeID":1043}],"affectedRows":0}
False
False