0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for users and developers of the Cardano cryptocurrency ecosystem

--How many users have a score above 1000, if you only include their posts 
--with a comment count of greater than or equal to ten? 

-- How many users have posts with scores that sum to > 1000
-- with a comment count of >= 10
SELECT SUM(Posts.Score), Posts.OwnerUserId FROM Posts
WHERE CommentCount >= 10
GROUP BY Posts.OwnerUserId
HAVING SUM(Posts.Score) > 1000

view current version

edited oct 11

created oct 11 jon.doe45961