How to match the closet date in sql (redshift)?

Question

For example, my table A is work_schedule:

Employee_id	Week_start	Work_schedule
A	2021-01-03	Day shift
A	2021-01-10	Day shift
A	2021-01-17	Night shift
B	2020-12-27	Day shift
B	2021-01-03	Day shift

question from:https://stackoverflow.com/questions/66056753/how-to-match-the-closet-date-in-sql-redshift

Answer 1

Waitting for answers