Need help SQL to pull Previous work schedules and present Work schedules of employees

Summary:

I am currently working on a project that requires retrieving both the previous and current work schedules for employees from our database. I would appreciate your expertise in crafting an SQL query that can achieve this.

I'm using this SQL Query below:

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):

SELECT
papf.person_number,
zss.schedule_name,
zsp.pattern_name,
zspd.day_start_num,
zspd.day_stop_num,
(zspd.day_stop_num + 1) - zspd.day_start_num AS days,