I need you to write the code for me and the name of the program I'm using is PostgreSQL. thank you

you can put any name you want into the column

you have to create your own movie class and data so you can create any type of movie and data. hope that will help you. thank you in advance

Instructions 1. Create the five tables for movies data by writing your own syntax, and insert sample data into corresponding tables. (Table details can be found in study materials - Topic 2 pdf) Sample data have been provided in Week 4 folder->Class Code & Files->Sample Data. Make the data ready to be used before Wednesday's class start: Run below queries and take a screen shot of the result. select count(*) from directors union select count(*) from actors union select count(*) from movie revenues union select count(*) from movies actors 2. Create the owners table: first name character varying 30) last name character varying 30) inte city character varying (30) state character Create the pets table (with a foreign key): species character varyang full name character varying 31 age integer owner Id Integer ter Add an email column to the owners table: OLY hawarg character character artnet Change the data type of the last_name column in the owners table to VARCHAR(50), run below queries and take a screen shot of the result. SELECT * FROM owners SELECT * FROM pets