pls solve all the questions using psql and functions in psql

Consider the following Database of movies Movies (M_no, M_name,release_year,budget) Actor (A_no,A_name,A_city,age) Producer (P_no, P_name,P_city,P_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