2) [50 points] Using the sakila database, create queries to do the following: Make sure to take screenshots of each outp
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
2) [50 points] Using the sakila database, create queries to do the following: Make sure to take screenshots of each outp
2) [50 points] Using the sakila database, create queries to do the following: Make sure to take screenshots of each output for submission on a report on Blackboard. a) Find all films that are have ever been rented. How many are there? b) How many films are rented out and have not been returned? c) How many films are overdue? d) Write an list of currently rented films (limit to 5 sorted by customer_id) and provide a screen dump of your query and results.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!