aliases are always needed when you add the same table twice; here'a i'm using an aribtrary T1 and T2;

it especially helps the query as well, as with your example, it looks like you are only selecting columns from the rxproductivity table, so it seems like there's no value to joining to the other tables;

maybe you were going to further enhance it to get the names from the other tables?

here's my best guess, without having the tables DDL to confirm anything:

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