0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for linguists, etymologists, and serious English language enthusiasts

-- Provide a leaderboard of users with correct answers who have 
-- commented on at least 10 unique posts and whose account is older than 6 months.

select Users.Id
from "Users"
join "Posts"
        on Users.Id = Posts.OwnerUserId
where Users.CreationDate > '2021-07-25 00:00:00'
and commentcount >= '10'
group by Users.Id

view current version

edited jan 26 22

created jan 26 22 anonymous