How can I use SQL to break comma-separated values into new rows

How can I use SQL to break comma-separated values into new rows

I  have the following dataset:

I need to use SQL to turn this dataset into the following:

i tried to used like this:

but it didn't worked.