0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for scientific skepticism

--How many users have more up votes than down votes, for users 
-- who made their accounts in 2022? 
--(Because this is a live database, your numbers may be slightly different than mine by the time you read this, so I'm putting this in large buckets so I can be confident that we'll get the same answer.) 
--SQL

SELECT Users.Id as UserId, Users.UpVotes, Users.DownVotes
FROM Users
WHERE Users.Upvotes > Users.Downvotes
And CreationDate > '2022-01-01 00:00:00'

fork query

edited nov 27

created nov 26 ChaMint