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

Question : A table named Prob_Contact contains the required frequency of contact with a probation officer, based on the length of the probation period (the number of days assigned to probation). Review the data in this table, which indicates ranges for the number of days and applicable contact frequencies.

Create a list containing the name of each criminal who has been assigned a probation period, which is indicated by the sentence type.

The list should contain the criminal name, probation start date, probation end date, and required frequency of contact. Sort the list by criminal name and probation start date.