This is a question from Oracle 12c SQL by Joan Casteel.Chapter 9, Hands-On Assignment.
Note: Two SQL queries (Query 1: Using traditional approach. Query 2: Using the JOIN keyword) are needed for this question.
Question : A column named Mgr_ID has been added to the Prob_Officers table and contains the ID number of the probation supervisor for each officer. Produce a list showing each probation officer's name and his or her supervisor's name. Sort the list alphabetically by probation officer name.