1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

-- Users by Location Having a Minimum Reputation
-- Search for users by the Location string and limit the results by a minimum reputation.
-- LocationLike: Enter '%ashville%' (including single quotes) to find users in 'Nashville, TN'

select top 1000
  id as [User Link],
  round((100.0 * (Reputation/10)) / (Upvotes+1), 2) as [Ratio %],
  Reputation as Rep, 
  UpVotes as [+ Votes],
  DownVotes [- Votes],
  Location,
  AboutMe,
  LastAccessDate
from Users
where Reputation > ##MinRep##
  and
  (Location like ##LocationLike##)
order by [Reputation] desc

fork query

edited mar 8 12

created mar 8 12 Robert Claypool