How to create new date rows for a group given a date range in sql?

Viewed 18

I have a table like this:

game | available_start_date | available_end_date
A    | 2020-01-01           | 2020-03-01
B...

Now, I want the outcome to look like this:

date       | game
2020-01-01 | A
2020-02-01 | A 
2020-03-01 | A
...

Is this possible in SQL?

0 Answers
Related