my ID No. is / 15f14045

Write the appropriate at statement for the following with screen shots of the execution: (30 Marks) NOTE: please add your student ID to add to the column names to avoid similarity: Table name: Country Column Name Data Type Constraint Integer CountryID Country Name Primary Key Not null Varchar ContinentName Varchar Phone No Integer Table Name: Plant Column Name Data Type Constraint Planti Integer Primary key REC_AMO TEM_035_02 Page 2 of 12 Fundamentals of Relational Database Management Systems (COMP 20002.1) - Fall-2020 - CW2 (Assignment2) - ALL-QP PlantName varchar Not null Type varchar Should not be less than 0.0 Height Numeric62) PlantedDate Date Country Integer References to country table a. Create country and Plant tables as per the above given structure (12 marks) b. Create a view that will display the total number of plants per type. (6 Marks) Change the planted date of plants which belongs to creeper or climber type to 31st Aug 2000 (6 Marks) d. Write a subquery to display the Plant ID, Plant name and continent name of all quotes that originates from the country tranor Australia (6 Marks)