SQL query for absence

Summary:

Hi,

I have to create a query with 2 types of abcence.

The data model is ready but i have to show each absence day in the seperate row,example: E123123 2023-10-20 2023-10-23

ID Start_date end_date

E123123 2023-10-20 2023-10-20

E123123 2023-10-21 2023-10-21

E123123 2023-10-22 2023-10-22

E123123 2023-10-23 2023-10-23

my code is in the attchment.

i try to solve it from a few days but still with no success.

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):