0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for expert genealogists and people interested in genealogy or family history

DECLARE @p_date DATETIME
 SET     @p_date = CONVERT( DATETIME, '01 JAN 2012', 106 )


(
SELECT 
q.AnswerCount,
	count(*) numPerguntas,
    avg(ViewCount)
FROM 
	Posts q
where 
	q.postTypeId = 1
    and q.AnswerCount < 5
group by q.AnswerCount
)
UNION
(
SELECT 
5,
	count(*) numPerguntas,
    avg(ViewCount)
FROM 
	Posts q
where 
	q.postTypeId = 1
     and q.AnswerCount >= 5
)
ORDER BY 1

fork query

edited apr 20 12

created apr 16 12 Hasan