PostgreSQL Practice #4

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 :