Write SQL statement to return movies of Director John Lasseter 7 8 9 9 6 4...

 

Transcribed Image Text:

Write SQL statement to return movies of Director John Lasseter 7 8 9 9 6 4 5 3 1 2 ld Title Toy Story A Dug's Life Toy Story 2 Monsters, Inc. Finding Nemo The Incredibles Cars 10 Up Ratatouille WALL-E 11 Toy Story 3 12 Cars 2 13 Brave 14 Monsters University Director John Lasseter John Lasseter John Lasseter Pete Docter Andrew Stanton Brad Bird John Lasseter Brad Bird Andrew Stanton Pete Docter Lee Unkrich John Lasseter Brenda Chapman Dan Scanlon Year 1995 81 1998 95 1999 2001 2003 2004 2010 Length minutes 2012 93 92 2006 117 2007 2008 104 2009 101 107 116 2013 110 115 103 2011 120 102 Table: Box office Movie M 5 14 8 12 3 6 9 11 1 7 10 4 2 13 Ruting 8.2 7A 8 6.4 7.9 8 8.5 8.4 8.3 7.2 8.3 8.1 7.2 7.2 Domestic sales International sales 355,900,000 475,066,343 417,277,164 368,400,000 239,163,000 370,001,000 297,503,696 648,167,031 170,162,503 217,900,167 438,338,580 272,900,000 200,600,000 301,700,000 380,843,261 268,492,764 206,445,654 191,452,396 245,852,179 261,441,092 223,808,164 415,004,880 191,796,233 244,082,982 293,004,164 289,916,256 162,798,565 237,283,207 Write SQL statement to return movies of Director John Lasseter 7 8 9 9 6 4 5 3 1 2 ld Title Toy Story A Dug's Life Toy Story 2 Monsters, Inc. Finding Nemo The Incredibles Cars 10 Up Ratatouille WALL-E 11 Toy Story 3 12 Cars 2 13 Brave 14 Monsters University Director John Lasseter John Lasseter John Lasseter Pete Docter Andrew Stanton Brad Bird John Lasseter Brad Bird Andrew Stanton Pete Docter Lee Unkrich John Lasseter Brenda Chapman Dan Scanlon Year 1995 81 1998 95 1999 2001 2003 2004 2010 Length minutes 2012 93 92 2006 117 2007 2008 104 2009 101 107 116 2013 110 115 103 2011 120 102 Table: Box office Movie M 5 14 8 12 3 6 9 11 1 7 10 4 2 13 Ruting 8.2 7A 8 6.4 7.9 8 8.5 8.4 8.3 7.2 8.3 8.1 7.2 7.2 Domestic sales International sales 355,900,000 475,066,343 417,277,164 368,400,000 239,163,000 370,001,000 297,503,696 648,167,031 170,162,503 217,900,167 438,338,580 272,900,000 200,600,000 301,700,000 380,843,261 268,492,764 206,445,654 191,452,396 245,852,179 261,441,092 223,808,164 415,004,880 191,796,233 244,082,982 293,004,164 289,916,256 162,798,565 237,283,207

Answer rating: 100% (QA)

On reference to your question where the table contains some of the c... View the full answer