SELECT SUM (CASE WHEN postcount < 10 THEN 1 ELSE 0 END) f...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Portuguese Language

Q&A for linguists, teachers and learners wanting to discuss the finer points of the Portuguese language

SELECT SUM (CASE WHEN postcount < 10 THEN 1 ELSE 0 END) first, 
SUM (CASE WHEN postcount >=10 AND postcount < 21 THEN 1 ELSE 0 END) sec, 
SUM (CASE WHEN postcount > 20 THEN 1 ELSE 0 END) third 
FROM (SELECT OwnerUserId, COUNT (PostTypeId) postcount 
FROM Posts WHERE PostTypeId = 1 GROUP BY OwnerUserId) x;

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results