please answer this by Using Apex Oracle

Program database programing. need accurate answer and should use apex oracle.

Assignment #2 (4%) Instruction: Include FULL Screenshot that display your code and output on Apex Exercise 1(1%) A. Create an anonymous block that returns the number of students in a section. Prompt for section id. Name the file P2.1.sql. Input: ENTER SECTION_ID 10001 Output: There are 5 students in section 10001 B. Create an anonymous block that return the average numeric grade for a section. Prompt for section id and return the average grade. Name the file P2.2.sql. Input ENTER SECTION ID 10001 Output The average grade in section 18001 is 19 . Exercise 2 (1%) Complete the following: Create a view called gl_stdV1 that returns the required data Create an anonymous block that: o Accesses gl_stdV1 o Uses the %ROWTYPE attribute to define a record structure for the view data o Prompts for student number and section id o Output the required information . Input HENTER STUDENT NO 1000 ENTER SECTION ID 10001 Output Student Grade Friday, May 7, 2025 Student Meagan Farenden Input: ENTER_STUDENT_NO 1eee : ENTER SECTION_ID 18001 Output: Student Grade: Friday, May 7, 2025 Student: Meagan Farenden Major: Nursing Course: Web Technologies I Section: 10001 Professor: Olivia Smith Grade: A Exercise 3 (2%): Create an anonymous block that inserts new rows into the gl_professors_copy table Declare variables using the %ROWTYPE and %TYPE attributes Use bind/host variables to prompt for the input data Allow for mixed case when entering the school code Allow for mixed case when entering the first and last names and format names with first character in upper case and the remaining character in lower case Include an INSERT statement in the execution section that inserts one row into the gl professors_copy table Run the block three times to insert the following rows into the table: Professor First Last Office Office School No Name Name No Ext Code 5011 Tom Allen 415 3621 CS 5012 Mary Page 476 3476 CS 5013 Andy Culp 501 3501 CS Verify the three rows were inserted correctly alaa Input: ENTER PROFESSOR NO TENTER FIRST NAME ENTER LAST NAME ENTER OFFICE NO ENTER OFFICE EXT ENTER SCHOOL CODE 5011 ton allen 415 3621 CS 1 Output Professor Added Professor no: 5011 First name: Tom Last name: Allen Old Office no: 415 01d Office ext: 3621 School Codes CS