SELECT qUserId , aUserId , COUNT( * ) AS N FROM ( SELECT...

0

Please login or register to vote for this query.

(click on this box to dismiss)

English

Q&A for linguists, etymologists, and serious English language enthusiasts

SELECT
	qUserId
,	aUserId
,	COUNT( * ) AS N

FROM (
	SELECT
		q.Id 								AS qId
	,	q.OwnerUserId 						AS qUserId
	, 	q.CreationDate 						AS qDate
	, 	q.AcceptedAnswerId 					AS aId
	,	a.OwnerUserId 						AS aUserId
	,	( a.CreationDate - q.CreationDate )	AS aDelay

	FROM
		Posts AS q
	
	INNER JOIN
		Posts AS a
	ON	a.Id = q.AcceptedAnswerId
)	AS	t

GROUP BY
	qUserId
,	aUserId

Enter Parameters

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