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

2023
Views:

355

Pages:

2
Author:

Alicia W.

02/09/2023 Answer this question below. 1. Make a SQL Query to show whose staff has the most rental transaction Answer : select s.first_name , s.last_name , count(r.rental_id) as "Rental Count" from staff s , rental r where s.staff_id = r.staff_id group by 1,2 limit 1 Here’s the output when we run the query : 2. Make a SQL Query to show 5 films with the highest length Answer : select f.title , max(f.length) as length from film f group by 1 order by 2 desc, 1 asc limit 5 Here’s the output when we run the query : 3. Make a SQL Query to show 10 actors name in alphabetical order Answer : select a.first_name , a.last_name from actor a order by 1 asc limit 10 Here’s the output when we run the query :