I need to create 10 entries( six month gap into redshift) into table like below.

Week_start_date Week_end_date
2024-01-01      2024-06-30(current_date)
2023-07-01      2023-12-31
2023-01-01      2023-06-30
2022-07-01      2022-12-31
2022-01-01      2022-06-30

…. so on this should be only for last 5 years from current date.

Can any one help to create SQL statement Redshift to generate these records

I tried SQL but its not working