Use ,

SELECT UserID,
       UserName,
       UserScore,
       MAX(UserScore) OVER () AS ScoreMax
FROM Users
WHERE UserScore > 30 
ORDER BY UserScore

See example

I recommend reading Window Function Concepts and Syntax