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

2023
Views:

284

Pages:

3
Author:

Alicia W.

04/09/2023 Answer this question below. 1. Make a SQL Query to show how much rental transaction every month Answer : select extract (year from rental_date), extract (month from rental_date), count(rental_id) from rental r group by extract (year from rental_date), extract (month from rental_date) order by 1,2 Here’s the output when we run the query : 2. Make a SQL Query to display film with “drama” word in its description. Answer : select f.title from film f left join film_category fc on f.film_id = fc.film_id left join category c on fc.category_id = c.category_id where upper(f.description) like '%drama%' limit 10 Here’s the output when we run the query :