select count(*) oprAccounts, sum( case when oprType = '*' then 1 else 0 end ) oprFocusAccounts, sum( case when profileComplete = 'Y' then 1 else 0 end ) oprAccountsComplete, sum( case when profileComplete = 'Y' and oprType = '*' then 1 else 0 end ) oprFocusAccountsComplete from tbl_OPR_ClientOperators opr inner join tbl_TER_Territories ter on ter.territoryId = opr.territoryId and ter.ownerId = opr.ownerId and ter.fsl_tablecode = opr.fsltablecode where ter.territoryId = inner join tbl_FSPro_members m on m.fspro_userId = opr.mfr_bsr_id and m.ownerId = opr.ownerId and m.fsl_tablecode = opr.fsltablecode where m.fspro_userId = and opr.crmActive = 'Y' and opr.ownerId = and opr.fsltablecode =