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