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).
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).
Chapter7: Database Administration
Section: Chapter Questions
Problem 6SCG
Related questions
Question
I need answer fast sql Oracle with screenshoot
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 3 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L