Oracle SQL - Creating a record count derived from dates within a table of data.

Sample Data.xlsx

I have two tables:

Table 1 - contains all the availability durations of a given user ID selecting available on a phone. each record contains the User ID, the first date / time the user set their phone number to available, then the subsequent date/time the user next set their phone number to available, in dd/mm/yyyy hh:mm:ss 

Table 2 - Shows the jobs registered along with a Date Allocated also in dd/mm/yyyy hh:mm:ss 

I wish to create a query that uses the two dates from table one (in each record) to obtain the record count of table 2. with the results as outlined in the Results sheet of the attached example. Can this be done, please can I get an experts help.

Thank you.