Assign correct Responsible person from JSON format column based on Service Date

Question

P.S. previous post was deleted, I hope this time it will reach more people.

I have huge history dataset and I need to assign value (ResponsibleName - from JSON format column) to a new 'Responsible' column based on Service Date for all rows associate with Client.

Each Client can have unique Responsible person (JSON column) for the specific date range:

1. If Codes Column contains Supervisor, then assign this Employee to only associated row as Responsible.
2. And finally, if Codes Column contains Employee, than assign associated Responsible person from the JSON column (for specific date range) to Responsible

I don't have issues with the first step, however I can't find a solution to implement the 2nd (last) statement.

Original History Table Joined with Client Table:

SELECT h.Id,
       h.ServiceDate
       h.ClientId,
       cl.ClientName,
       h.EmployeeName,
       cl.ResponsibleJSON,
       h.Codes
FROM History AS h
JOIN ClientTable AS cl
   ON (h.ClientId = cl.ClientId)

Output of that table:

Id	ServiceDate	ClientId	ClientName	EmployeeName	ResponsibleJSON	Codes
1	2020-05-06	123	John Smith	Chris Evans	[{"ResponsibleName":"Kevin Costner","ResponsibleStartDate":"2019-02-14","ResponsibleEndDate":"2020-05-31"},{"ResponsibleName":"Tom Cruise", "ResponsibleStartDate":"2020-06-01","ResponsibleEndDate":null}]	Employee, Office
2	2020-05-08	123	John Smith	Tom Holland	[{"ResponsibleName":"Kevin Costner","ResponsibleStartDate":"2019-02-14","ResponsibleEndDate":"2020-05-31"},{"ResponsibleName":"Tom Cruise", "ResponsibleStartDate":"2020-06-01","ResponsibleEndDate":null}]	Supervisor, Remote
3	2020-05-11	123	John Smith	Chris Evans	[{"ResponsibleName":"Kevin Costner","ResponsibleStartDate":"2019-02-14","ResponsibleEndDate":"2020-05-31"},{"ResponsibleName":"Tom Cruise", "ResponsibleStartDate":"2020-06-01","ResponsibleEndDate":null}]	Employee, Office
4	2020-05-15	123	John Smith	Thomas Anderson	[{"ResponsibleName":"Kevin Costner","ResponsibleStartDate":"2019-02-14","ResponsibleEndDate":"2020-05-31"},{"ResponsibleName":"Tom Cruise", "ResponsibleStartDate":"2020-06-01","ResponsibleEndDate":null}]	Employee, Office
5	2020-06-10	123	John Smith	Tom Holland	[{"ResponsibleName":"Kevin Costner","ResponsibleStartDate":"2019-02-14","ResponsibleEndDate":"2020-05-31"},{"ResponsibleName":"Tom Cruise", "ResponsibleStartDate":"2020-06-01","ResponsibleEndDate":null}]	Supervisor, Office
6	2020-06-17	123	John Smith	Thomas Anderson	[{"ResponsibleName":"Kevin Costner","ResponsibleStartDate":"2019-02-14","ResponsibleEndDate":"2020-05-31"},{"ResponsibleName":"Tom Cruise", "ResponsibleStartDate":"2020-06-01","ResponsibleEndDate":null}]	Employee, Remote
7	2020-06-22	123	John Smith	Elon Mask	[{"ResponsibleName":"Kevin Costner","ResponsibleStartDate":"2019-02-14","ResponsibleEndDate":"2020-05-31"},{"ResponsibleName":"Tom Cruise", "ResponsibleStartDate":"2020-06-01","ResponsibleEndDate":null}]	Employee, Remote
8	2020-07-01	123	John Smith	Tom Holland	[{"ResponsibleName":"Kevin Costner","ResponsibleStartDate":"2019-02-14","ResponsibleEndDate":"2020-05-31"},{"ResponsibleName":"Tom Cruise", "ResponsibleStartDate":"2020-06-01","ResponsibleEndDate":null}]	Supervisor, Remote

I've created the table with all JSON data for all Clients:

SELECT  c.ClientId,
        c.ClientFullName,
        c.ResponsibleJSON,
        JSON_VALUE(X.VALUE,'$.ResponsibleName') AS ResponsibleName,
        JSON_VALUE(X.VALUE,'$.ResponsibleStartDate') AS ResponsibleStartDate,
        ISNULL(JSON_VALUE(X.VALUE,'$.ResponsibleEndDate'), '2999-12-31') AS ResponsibleEndDate

FROM ClientTable AS c
CROSS APPLY OPENJSON(c.ResponsibleJSON) AS X
ORDER BY c.ClientFullName, ResponsibleStartDate

And now I need to combine them somehow to produce column below:

Desired Output:

Responsible
Kevin Costner
Tom Holland
Kevin Costner
Kevin Costner
Tom Holland
Tom Cruise
Tom Cruise
Tom Holland

Code I need help with you can find below. I don't know if I can OUTER APPLY in CASE statement AND I think JOIN should be ON ClientId and check if ServiceDate between ResponsibleStartDate AND ResponsibleEndDate.

SELECT h.Id,
       h.ServiceDate
       h.ClientId,
       cl.ClientName,
       h.EmployeeName,
       cl.ResponsibleJSON,
       h.Codes,

       CASE
          WHEN h.Codes LIKE '%Supervisor%' THEN h.EmployeeName --- 1st statement
          WHEN --- here should be the second statement. I don't know how to implement it.
       END AS Responsible

FROM History AS h
JOIN ClientTable AS cl
   ON (h.ClientId = cl.ClientId)