University:
California State University, Northridge
Course:
IS 441 | Database Management Systems
Academic year:

2023
Views:

474

Pages:

2
Author:

Alicia W.

03/09/2023 Answer this question below. 1. Make a SQL Query to display film list along with average its rental price Answer : select c.name, avg(f.rental_rate) from film f left join film_category fc on f.film_id = fc.film_id left join category c on c.category_id = fc.category_id left join rental r on r.rental_id = f.rental_rate group by 1 order by 2 desc Here’s the output when we run the query : 2. Make a SQL Query to display the average loan in days Answer : SELECT AVG(EXTRACT(day FROM return_date - rental_date)) FROM rental r Here’s the output when we run the query :