Here is the full query:

SELECT tName as 'Name'
, ISNULL(u.mCnt,0) AS 'Total count'
, ISNULL(aF.aFCnt,0) AS 'aF Count'
, ISNULL((u.mCnt - aF.aFCnt),0) AS 'Not aF Count'
, ISNULL(100 - (ISNULL(CAST((CAST(nF.nFStatusCnt AS...