SELECT COUNT(*) + 1
FROM leaderboard ur, users u
WHERE u.country='United States' and ur.id=u.id and ur.score>
(SELECT ur2.score
 FROM leaderboard ur2
 WHERE ur2.id = user_id);

SELECT COUNT(*) + 1
FROM leaderboard ur
WHERE ur.score > (SELECT ur2.score FROM leaderboard ur2 WHERE ur2.id = user_id