Applying It

Independent Exercise 1:

• Create a PL/SQL Procedure that displays the total employee count and the total salary by department.
  
  

Independent Exercise 2:

• Create a PL/SQL Procedure that gives the DEPT 10 people a 10% increase in salary and the DEPT 20 people a 20% increase in salary.
  
  

Independent Exercise 3:

• Create a Function that outputs the total amount of salary only after the last row has been processed.
  
  
• Drop the PEOPLE table.