Find useres that have been members for a shorter time than me
but have more reputation points.
Q&A about the site for physical fitness professionals, athletes, trainers, and those providing health-related needs
-- Newer Users with More Reputation Than Me
-- Find useres that have been members for a shorter time than me
-- but have more reputation points.
declare @UserId int = ##UserId##
select u.id as [User Link], u.Reputation, u.Reputation - me.Reputation as Difference
from users u cross join users me
where me.id = @UserId
and u.CreationDate > me.CreationDate
and u.Reputation > me.Reputation
order by Difference desc, u.CreationDate Desc