0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people interested in the history and origins of science and mathematics

SELECT 
    q.AnswerCount,
	count(*) numPerguntas
FROM 
	Posts q
where 
	q.postTypeId = 1
      and (exists (
                  select
                      1
                  from 
                       posts a
                  where
                       a.Score > 0
                       and a.parentId = q.id
                       )
                       )
 group by q.AnswerCount

view current version

edited apr 20 12

created apr 16 12 Hasan