1.in SQl Create an anonymous block that returns the number of students in a section. Prompt for section id. Name the file P2.1.sql.

2.in Sql Create an anonymous block that returns the average numeric grade for a section. Prompt for section id and return the average grade. Name the file P2.2.sql.

3.In sql Create an anonymous block that returns the number of sections offered for a given course. When prompting course code, allow for mixed cases, such as cis100, CIS100, and CiS100, and so on. Name the file P2.3.sql.

4 in sql . Complete the following: Create a view called gl_stdV1 that returns the required data Create an anonymous block that: o Accesses gl_stdV1