Question: 2. Answering Questions based on a database (a) (5 points) Print out a tabulated list containing the original_title, usa_gross_income, and date_published of the top 10

 2. Answering Questions based on a database (a) (5 points) Print

2. Answering Questions based on a database (a) (5 points) Print out a tabulated list containing the original_title, usa_gross_income, and date_published of the top 10 movies with the highest usa_gross_income. (Hint: See slide 38 and 39 of the lecture for week 8 to learn about ordering/sorting data. You can append the command "LIMIT N" to a SQL Query to limit the number of values returned). Expected Output Star Wars: Episode VII - The Force Awakens $936,662,225 12/16/2015 Avengers: Endgane $858,373,000 04/24/2019 Avatar $760,507,625 01/15/2010 Black Panther $700,426,566 02/14/2018 Avengers: Infinity War $678,815,482 04/25/2018 Titanic $659,363,944 01/16/1998 $652, 270,625 06/11/2015 The Avengers $623,357,910 04/25/2012 Star Wars: Episode VIII - The Last Jedi $620,181,382 12/13/2017 Incredibles 2 $608,581,744 09/19/2018 (b) (5 points) Print out the original_title, genre, avg_vote of the most popular movie based on avg_vote. (c) (5 points) Prompt the user for a partial movie title (original_title) and print out a numbered list of actors for that movie (d) (5 points) Print out the original_title and duration of the movie with the longest runtime. The duration must be formatted as hh hr mm min (Example: 02 hr 16 min) Jurassic World The file is too big for my computer If you have challenges handling a file of 50MB on your local computer, you may work on Google Colaboratory, This will allow you to store and work with files on Google Drive. You may use the following piece of code to download the dataset to your colab workspace: https://repl.it/fnembhard/11ledownloader Click the icon on the left panel in Colaboratory to see the set of files in your workspace. Read more about working with files on Colaboratory here: https://www.google.com/amp/septune.ai/blog/ google-colab-dealing-with-files/amp

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!