SELECT
        COALESCE(Sector.Sector,'') as "Asset Type",
        CAST (SUM (N.exposureFundPerNAV) *100 AS VARCHAR(20))
        END AS "Percentage"

FROM Nav AS N
INNER JOIN Fund ON N.fund = F.FC