SQL> @ 328lect05-1

Function created.

No errors.
=====
TESTING job_count
=====
=====
SHOULD see that there is 1 President:
=====

PL/SQL procedure successfully completed.


   NUM_JOB                                                                      
----------                                                                      
         1                                                                      

=====
SHOULD see that there are 4 with Sales:
=====

PL/SQL procedure successfully completed.


   NUM_JOB                                                                      
----------                                                                      
         4                                                                      

=====
SHOULD see that there are 0 with Kitten Wrangler:
=====

PL/SQL procedure successfully completed.


   NUM_JOB                                                                      
----------                                                                      
         0                                                                      


Procedure created.

No errors.
=====
TESTING job_overview
=====
=====
Should see President, 1, and $5000
=====
Job Title:  President                                                           
# with Job: 1                                                                   
Avg Salary: $5000                                                               

PL/SQL procedure successfully completed.

=====
Should see Sales, 4, and $1400
=====
Job Title:  Sales                                                               
# with Job: 4                                                                   
Avg Salary: $1400                                                               

PL/SQL procedure successfully completed.

=====
Should see a message saying there ARE no Kitten Wranglers
=====
There are NO employees with job title of Kitten Wrangler                        

PL/SQL procedure successfully completed.

SQL> spool off