select sum(b.count) from (SELECT AnswerCount, COUNT(*) AS...

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(b.count) from (SELECT AnswerCount, COUNT(*) AS count 
FROM Posts GROUP BY AnswerCount) b where b.count > 1 and AnswerCount is not null;


select 
sum(a.num_of_posts) as num_of_posts 
from (
  select
  count(*) as num_of_posts,
  answercount
  from posts
  where answercount is not null and answercount >=0
  group by answercount
  having count(*)>1
) a

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results