Stats on questions containing string

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT
COUNT(Id) as 'Total Count',
AVG(Score + 0.0) as 'Avg Score',
COUNT(ClosedDate)*100.0/COUNT(Id) as '% Closed'
FROM Posts

WHERE 
Posts.PostTypeId=1
AND
Posts.CreationDate >= GETDATE() - 60
AND
(lower(Posts.Body) LIKE lower('%go about this%'))

Enter Parameters

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