3. List only the total number of movies in the table.Take a screenshot now and paste it here.4. List the title and year for the 5 oldest movies in the table. Hint: LIMIT.Take a screenshot now and paste it here.5. List only the average rating for the movies from the 90's.Take a screenshot now and paste it here. mysql> SELECT * FROM movie;+----| id | title+-| 1 | Abominable2||||Hotel TranslyvaniaOnward34 | Sing5 | The SpongeBob Movie6 | Toy Story7 | Toy Story 28910Toy Story 3Toy Story 4SoulSurf's Up1112 | Trolls13 | Trolls World Tour| 14 | Zootopia| 16 | Howl's Moving Castle| 17 | Happy Feet+---16 rows in set (0.00 sec)I year | duration | gross | rating I| 2019179.1 || 2012358.3 |2020142.0 |2016634.2 |202019951999| 2010| 2019| 202020072016202020162004| 20069791102108 |91 |8192 |1031066.9 |100 | 1073.4 |100 |NULL |85152.0 |9290 |346.9 |NULL1023.8 |236.2 |384.3 |108NULL |373.6 |497.3 |119 |1085.09.08.38.38.77.99.0 |8.3 |9.54.7 |5.09.0 |8.7 |8.3 |8.2 I6.4 |

Solution: Given table: id title year duration gross rating 1 Abominable 2019 97 179.1 5 2…

3. List only the total number of movies in the table. Take a screenshot now and paste it here. 4. List the title and year for the 5 oldest movies in the table. Hint: LIMIT. Take a screenshot now and paste it here. 5. List only the average rating for the movies from the 90's. Take a screenshot now and paste it here.

3. List only the total number of movies in the table. Take a screenshot now and paste it here. 4. List the title and year for the 5 oldest movies in the table. Hint: LIMIT. Take a screenshot now and paste it here. 5. List only the average rating for the movies from the 90's. Take a screenshot now and paste it here.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Question 7 1 pts Choose the correct special sequence that returns a match where the string DOES NOT contain any word characters : O Is O lw O IS O IW
please provide step-by-step instructions
Question 9 Draw a perspective drawing of the following shape, using the vanishing point provided.
Below, we'll break down the differences between MonthCalendar and DateTimerPicker.
Create lookup functions to complete the summary section. In cell I6, create a formula using the VLOOKUP function to display the number of hours worked in the selected week. Look up the week number in cell I5 in the range A17:G20, and return the value in the 2nd column. Use absolute references for cell I5 and the range A17:G20.
Output the information in a formatted table. The title is right justified with a width of 33. Column 1 has a width of 20. Column 2 has a width of 23. Ex: Number of Novels Authored Author name | Number of novels -------------------------------------------- Jane Austen | 6 Charles Dickens | 20 Ernest Hemingway | 9 Jack Kerouac | 22 F. Scott Fitzgerald | 8 Mary Shelley | 7 Charlotte Bronte | 5 Mark Twain | 11 Agatha Christie | 73 Ian Flemming | 14 J.K. Rowling | 14 Stephen King | 54 Oscar Wilde | 1
The incomplete box plot and table show some information about some marks. Use the information in the table to complete the box plot. Use the information in the box plot to complete the table.
Task 12: List the item ID, description, and category for each pair of items that are in the same category. (For example, one such pair would be item FS42 and item PF19, because the category for both items is FSH.) Order the output by category.
With the frmTutorSearch form still open in Design View, use the Title button to add a title to the form. Replace the default title text with Tutor Information Form. (Hint: Do not include the period.) Save and close the frmTutorSearch
Give names of manufacturers and their cities that are located in cities with names ending with 'City'. Give all the data for sales from January 21 of 2015 through the end of the month. (Use BETWEEN) List the information of each sale item where 2 or more items were sold but only for sizes 5, 6, and 7 (Use the keyword IN.) Show all sale item information. Give date and the sum of tax and shipping for each sale from December 20th through December 25th of 2015. (use BETWEEN. Name the calculated column SUM) Create an alphabetical list of names (first and last, alphabetized by last) of customers in Minnesota. What is the customerID for Sam Gill? What are the sales dates and shipping amount of sales with over $55 of shipping charges? List the data in the Salaried Employees table about Salaried Employees earning between $40000 and $50000. (use between) Give full names of customers that have a 'D' as the third character in their last names. Eliminate duplicates. Give names of manufacturers…
"""Q3: Create a series called 'directors' that contains each director's name and his or her average rating. Print out the type of your variable.Use the 'directors' series to find the average rating for Steven Spielberg. Print the value.""" Please help I keep getting series are different!!
Write a coffee script to find how many days left for international yoga day. Handle all the cases