The following query displays select fields from the Users table. Modify the query to display the users ordered by decreasing reputation.
Q&A for scientific skepticism
rank() OVER(PARTITION BY OwnerUserId order by CreationDate asc) as promo_level
where OwnerUserId in
(select id as OwnerUserId from users
where CreationDate < CONVERT(date, dateadd(year, -2, getdate()))
and OwnerUserId != -1
where promo_level = 10 or promo_level = 100 or promo_level = 1000