Respostas por questão

0

Please login or register to vote for this query.

(click on this box to dismiss)

History of Science and Math

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

select
	numResps,
	count(*)
from
(
SELECT 
	q.id,
	count(distinct a.id) numResps
FROM 
	Posts q,
	Posts a,
	Votes v
where 
	q.postTypeId = 1
	and a.postTypeId = 2
	and a.parentId = q.id
	and v.postId = a.id
group by q.id
)resps
group by numResps

Enter Parameters

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