Find useres that have been members for a shorter time than me but have more reputation points.
Q&A for people interested in all aspects of producing and consuming coffee
-- 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