Just solve question 2

QUESTIONS 1. (25 pts.) Write the SQL statements to create a ylew that will display student names and sum of students by section. 2. (75 pts.) Create a PL/SQL procedure which accepts a course code (ccode) and deletes the corresponding corse from COURSE table. (40 pts.) - The procedure accepts a course code. (5 pts.) - If the course code exists, the procedure assigns the sections' information to NULL and then it deletes the course. (10pts.) - If the course code does not exist, the procedure handles the exception and prints a descriptive text. (10pt5.) - Write a simple anonymous block with the procedure call to test it. (10pt5.) Note1: PK Primary Key FK Foreign Key NN Not Null Note2: You can find sample data on the back of the page. ANSWERS 4AMDLE DATA