pls solve views part using psql

signment 7 : Revision on functions and views 1. Consider the following Database of movies Movies (M_no, M_name,release_year,budget) Actor (A_no, A_name, A_city,age) The relationships are as follows: Movies-Producers - M : M Movies-Actor - M: M with descriptive attribute role and charges Functions a) Write a function to display number of movies released in year 2004 . b) Write a function to display release year of a given movie c) Write a function to display a city and birthdate of a given actor d) Write a function do display information of actor for given actor no Write a function to display information of producers for given city (use for loop and row type) e) Write a function to accept a actor name and movie name and display its role f) Write a function to accept producer name and display number of movies produced by him g) Write a function to accept actor name and display name of movies in which actor has worked Views a) Create a view which will contain information of all actors age less than 30 b) Create a view which will contain information of movies released after 2004 c) Create a view which will contain information of all producers from pune city Using above created view solve following queries. 1. Display number of actors with age more less than 20 from pune city 2. Display information of movies released in the year 2019 3. Display number of movies produced by producers living in pune 4. Display roles played by actors with age less than 20 movies released in 2021