0

Please login or register to vote for this query.

(click on this box to dismiss)

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;

fork query

edited nov 30

created nov 18 19 anonymous