query

select
    SaleTbl.id as 'sale number',
    STRING_AGG(
    CONCAT(ProductTbl.name,'x',cast(SoldProductsTbl.quantitySold      as nvarchar)),','+ char(13)+char(10)) AS 'sold products',
    username
from SoldProductsTbl
left join ProductTbl on ProductTbl.id = SoldProductsTbl.productID
left join SaleTbl on SaleTbl.id = SoldProductsTbl.saleID
left join UserTbl on UserTbl.id = SaleTbl.userID