I need answer fast sql Oracle with screenshoot Answer the following questions, depending on the attached tables:Table: BoxofficeTable: MoviesMovie_idRating Domestic_salesInternational_salesldTitleDirectorYearLength_minutesToy StoryA Bug's LifeToy Story 28.23808432615559000001John Lasseter199581147.42684927644750668432John Lasseter1998958.82064456544172771643John Lasseter199993126.41914523963684000004Monsters, Inc.Pete Docter2001927.9245852179239163000Finding NemoAndrew Stanton 20031078261441092370001000The IncrediblesBrad Bird20041169.8.52238081642975036967CarsJohn Lasseter20061172007Andrew Stanton 2008118.44150048806481670318RatatouilleBrad Bird11518.31917962331701625039.WALL-E10477.224408298221790016710UpPete Docter2009101108.329300416443833858011Toy Story 3Lee Unkrich201010348.128991625627290000012Cars 2John Lasseter201112013Brenda Chapman 201220137.2162798565200600000Brave102137.223728320730170000014 Monsters UniversityDan Scanlon110a) Create PROCEDURE to print the domestic and international sales with YEAR for eachmovie and test it (Write a program where you use this procedure and show the results).Title – Year - Domestic Sales - International Salesb) Create FUNCTION to return the number of movies that length more than 100 minutesusing IF and test it (Write a program where you use this function and show the results).c) Create FUNCTION to return the longest movie in Movies table and test it (Write aprogram where you use this function and show the results).

Answer: Code Snippet: 1. Procedure to display few column data. CREATE OR REPLACE PROCEDURE…

Answer the following questions, depending on the attached tables: Table: Boxoffice Table: Movies Movie_id Rating Domestic_sales International_sales Id Title Director Year Length_minutes Toy Story A Bug's Life Toy Story 2 8.2 380843261 555900000 1 John Lasseter 1995 81 14 7.4 268492764 475066843 John Lasseter 1998 95 8 8 206445654 417277164 3 John Lasseter 1999 93 12 6.4 191452396 368400000 4 Monsters, Inc. Pete Docter 2001 92 Finding Nemo The Incredibles 3 7.9 245852179 239163000 5 Andrew Stanton 2003 107 261441092 370001000 Brad Bird 2004 116 9. 8.5 223808164 297503696 7 Cars John Lasseter 2006 117 11 8.4 415004880 648167031 8 Ratatouille Brad Bird 2007 115 1 8.3 191796233 170162503 9 WALL-E Andrew Stanton 2008 104 10 11 7 7.2 244082982 217900167 Up Toy Story 3 Pete Docter 2009 101 10 8.3 293004164 438338580 Lee Unkrich 2010 103 4 8.1 289916256 272900000 12 Cars 2 John Lasseter 2011 120 13 14 Monsters University Brenda Chapman 2012 2013 7.2 162798565 200600000 Brave 102 13 7.2 237283207 301700000 Dan Scanlon 110 a) Create PROCEDURE to print the domestic and international sales with YEAR for each movie and test it (Write a program where you use this procedure and show the results). Title – Year - Domestic Sales - International Sales b) Create FUNCTION to return the number of movies that length more than 100 minutes using IF and test it (Write a program where you use this function and show the results). c) Create FUNCTION to return the longest movie in Movies table and test it (Write a program where you use this function and show the results).

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter7: Database Administration

Section: Chapter Questions

Problem 6SCG