STRING_AGG is to T-SQL what GROUP_CONCAT is to MySQL.

Use it to aggregrate stuff in a GROUP BY query in T-SQL.