I have 2 tables like this

table1

table2

I’m trying to write a SQL query which will convert these month weeks into dates and assign it to each WTG sequentially, to get an output which looks like this:

I’m considering the dates like this:
W1-7,
W2-14,
W3-21,
W4-28,
W5-31/30

Any help is appreciated.