PL/SQL - Create Anonymous Blocks

For each question, you must use a cursor, a while loop and an if-then-else.

1. Create an anonymous block that will count the number of students whose gr_t1 grade is higher than the average on gr_t1 and display that number.

2. Create an anonymous block that will give display the name of student if the average of his gr_t1 and gr_t2 is greater than the average of his gr_hw and gr_pr.

3. Create an anonymous block that will give display the name of student of the female students.

Tables:

student (std_code , std_fname, std_lname, std_gend, maj_code, std_dob)

grade (std_code, std_fname, std_lname, gr_t1, gr_t2, gr_hw, gr_pr, gr_avg, gr_lg)