1- Write a PL/SQL procedure named Salary_Report to show the number of salaries in each category as...
Question:
1- Write a PL/SQL procedure named Salary_Report to show the number of salaries in each category as follows: If the salary of Instructor is less than the average salary then the category is LOW Else the category is HIGH. The stored procedure must print how many of LOW and HIGH recordings are available in the database.
2- What type of PL/SQL cursors are available? What is the purpose of them, explain with an example.
3- For each school code, write SQL query to display school code and how many instructors work for that school. Include only schools that involve more than one instructor. Sort the output so that school codes with the most instructors involved are shown first.
4- Write SQL query to display last name and salary for all instructors who earn less than the Lowest salary in ANY school. Sort the output by top salaries first and then by last name. You must use sub-query.