Q&A for professionals and students of engineering
SELECT Users.Reputation AS Rep, ROW_NUMBER() OVER(ORDER BY Users.Reputation) FROM Posts INNER JOIN Users ON Posts.OwnerUserId=Users.Id WHERE ( Posts.ViewCount>##viewsThreshold## AND Users.Reputation<##repThreshold?100000## )