0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for people who want to be financially literate

select top 30
  ROW_NUMBER() OVER(ORDER BY reputation desc, views desc) AS [#],
  u.id as [User Link], u.age, u.reputation, u.views, u.location
from users u
where
  lower(u.location) like '%florida%'
  or upper(u.location) like '%FL'
order by u.reputation desc, u.views desc

fork query

edited oct 18 17

created may 2 16 anonymous