Combining query into one

How to take the result of formatting module data of below query when selecting the whole table by which means combine these two statement into one select StudentName, Email, Module from Student select s.items declaration from Student t1 outer apply dbo.Split(t1.Module, ‘,’) s Note: I’m using SQL server 2017 Cureent Modules: Math, English,Science Expected Modules:…

Details