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

2023
Views:

265

Pages:

2
Author:

Alicia W.

10/09/2023 Answer this question below. 1. Make a SQL Query to show actor with the highest film count Answer : SELECT a.actor_id, a.first_name, a.last_name, count(fa.film_id) AS film_count FROM actor a , film_actor fa WHERE a.actor_id = fa.actor_id GROUP BY a.actor_id, a.first_name, a.last_name ORDER BY film_count DESC LIMIT 5 Here’s the output when we run the query : 2. Make a SQL Query to display 10 customers with the highest rental count and total payment amount. Answer : SELECT c.customer_id, c.first_name, c.last_name,count(r.rental_id) AS rental_count, SUM(p.amount) as total_amount FROM customer c LEFT JOIN rental r on c.customer_id = r.customer_id LEFT JOIN payment p on c.customer_id = p.customer_id GROUP BY 1,2,3 ORDER BY 4 DESC limit 10 Here’s the output when we run the query :