0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for science fiction and fantasy enthusiasts

--  select top 500
  
  select all
  id as [User Link],
  Reputation as Rep, 
  UpVotes as [+ Votes],
  DownVotes [- Votes],
  LastAccessDate as [Last Access],
  cast(cast(UpVotes as float)/cast(DownVotes as float) as numeric(10,2)) as Ratio
from Users
where DownVotes > ##MinDownVotes##
AND LastAccessDate > '2024-01-01'

  -- order by [Ratio] asc
  -- order by [LastAccessDate] asc
  
  order by [LastAccessDate] desc

view current version

edited jul 12

created jul 4 stumblebee