Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Q4 (2 point + 1 bonus point): Use Movie_Data to answer the following questions. Q4a (2 point): Create a Pivot Table to find that, for
| Q4 (2 point + 1 bonus point): Use "Movie_Data" to answer the following questions. | |||||||||
| Q4a (2 point): Create a Pivot Table to find that, for each major production country, | |||||||||
| what is the highest revenue for drama and non-drama movie? | |||||||||
| Q4b (1 bonus point): Create a different Pivot Table to help you fill the following table (Cells B11:G17) | |||||||||
| Fill in average vote_average for all the drama movies that are released after 1/1/2010. | |||||||||
| Release Year | Run Time | ||||||||
| 80-99 | 100-119 | 120-139 | 140-159 | 160-179 | 180-199 | ||||
| 2010 | |||||||||
| 2011 | |||||||||
| 2012 | |||||||||
| 2013 | |||||||||
| 2014 | |||||||||
| 2015 | |||||||||
| 2016 | |||||||||
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Database Management Systems Designing And Building Business Applications
Authors: Gerald V. Post
1st Edition
0072898933, 978-0072898934
