PostgreSQL Practice #1

p {margin: 0; padding: 0;} .ft00{font-size:18px;font-family:NimbusRomanRegular;color:#000000;} .ft01{font-size:18px;font-family:NimbusMonoPSRegular;color:#000000;} 01/09/2023 Answer this question below. 1. Make a SQL Query to show all films and its description in the store. Answer : select f.title , f.description from film f Here’s the output when we run the query : 2. Make a SQL Query to show how many film that released in 2006. Answer : select count(f.film_id) as "Jumlah Film" from film f where f.release_year = 2006 Here’s the output when we run the query :