SELECT
  R1.whoverified,
  R1.whochecked AS 'userid',
  T1.Name as VerifiedUser,
  T2.Name  as WhoCheckedUser,
  COUNT(*)   whoverified,
  COUNT (*)  whochecked
FROM   rxproductivity R1
       JOIN users T1
         ON R1.whoverified = T1.userid
       JOIN users T2
         ON R1.whochecked = T2.userid
GROUP  BY
  R1.whoverified,
  R1.whochecked,
  T1.Name,
  T2.Name
HAVING
  COUNT(R1.whoverified) > 1
ORDER  BY
  COUNT(R1.whoverified) DESC 

SELECT	U.userid,
	SUM( CASE WHEN U.userid = P.whoverified THEN 1 ELSE 0 END ) AS whoverified,
	SUM( CASE WHEN U.userid = P.whochecked THEN 1 ELSE 0 END ) AS whochecked
FROM	users AS U
INNER JOIN rxproductivity AS P ON U.userid = P.whoverified OR U.userid = P.whochecked
GROUP BY U.userid