Untitled

SELECT [TrendName]
      ,[AssetName]
      ,STRING_AGG(Tags,' , ') as Tags
FROM [dbo].[TrendTags]
WHERE [TrendName]=[[trendName]]
GROUP BY [TrendName],[AssetName]