SQL Query needed

See attached detail but overall I have to parse a comma-separated field in a DB table and then do some calculations based on the parse. I'd like the result to return in a SELECT statement but am open to other options