Homework answers / question archive / City State Mayor CITY TheaterNum Address Phone City State Capacity THEATER MovieNum Title Year Length Type DirName ProdName Revenue MOVIE TheaterNum MovieNum SHOWINGS DirName Dir Address Dir Cell DIRECTOR ProdName Prod Addr Proc Cell PRODUCER ActorNum ActorName CurrentAge PlaceBirth ACTOR ActorNum PreviousJob PREVIOUSJOB ActorNum MovieNum Star ACTEDIN NewsName City State NEWSPAPER RevName Years Work REVIEWER ReviewNum Text Date MovieNum NewsName RevName REVIEW Questions Remember to follow all of the instructions listed on the first page

City State Mayor CITY TheaterNum Address Phone City State Capacity THEATER MovieNum Title Year Length Type DirName ProdName Revenue MOVIE TheaterNum MovieNum SHOWINGS DirName Dir Address Dir Cell DIRECTOR ProdName Prod Addr Proc Cell PRODUCER ActorNum ActorName CurrentAge PlaceBirth ACTOR ActorNum PreviousJob PREVIOUSJOB ActorNum MovieNum Star ACTEDIN NewsName City State NEWSPAPER RevName Years Work REVIEWER ReviewNum Text Date MovieNum NewsName RevName REVIEW Questions Remember to follow all of the instructions listed on the first page

Computer Science

Share With

City State Mayor CITY TheaterNum Address Phone City State Capacity THEATER MovieNum Title Year Length Type DirName ProdName Revenue MOVIE TheaterNum MovieNum SHOWINGS DirName Dir Address Dir Cell DIRECTOR ProdName Prod Addr Proc Cell PRODUCER ActorNum ActorName CurrentAge PlaceBirth ACTOR ActorNum PreviousJob PREVIOUSJOB ActorNum MovieNum Star ACTEDIN NewsName City State NEWSPAPER RevName Years Work REVIEWER ReviewNum Text Date MovieNum NewsName RevName REVIEW Questions Remember to follow all of the instructions listed on the first page. 1. Which theater(s) in Tennessee have the largest capacity? 2. How many reviews were written for each movie directed by John Carter that were filmed in the period 2014 to 2019 3. List the phone number of every theater in Tennessee. Order the results by theater number. 4. What was the total revenue generated by movies made in 2015 that were both directed by James Smith and produced by Mary Jones? 5. Assume there is only one movie titled, "The Matrix." Who reviewed it? 6. List the cities in Tennessee that have theaters with capacities of at least 200 seats. List the cities in alphabetic order

7. Which movies have generated more revenue than the movie directed by John Carter in 2010 that generated the most revenue of the movies he directed that year? 8. Which theaters in Tennessee, Arkansas, or Mississippi (you may use 2-letter abbreviations) showed movies whose titles began with any of the letters R, S, or T? List the theaters in numeric order. 9. Who is the oldest actor who starred in a movie made between 1995 and 2005 that was both directed by James Smith and produced by Mary Jones? 10. What was the total revenue generated by movies produced by each producer from 2010 to 2018 that starred an actor who is currently under 40 years of age? Only include producers whose movies generated more than a total of $75,000,000. l