Do good questions have question marks?

0

Please login or register to vote for this query.

(click on this box to dismiss)

Gardening and Landscaping Meta

Q&A about the site for gardeners and landscapers

SELECT COUNT(*) AS [Count],
       SUM(Score) as [Sum],
       SUM(FavoriteCount) as FavoriteCount,
       CAST(SUM(Score) AS decimal) / COUNT(*) AS AverageScore,
       CAST(SUM(FavoriteCount) AS decimal) / COUNT(*) AS AverageFavoriteCount,
       CASE WHEN BODY LIKE '%?%' OR Title Like '%?%' THEN 1 ELSE 0 END AS QuestionMark
FROM Posts
WHERE PostTypeId = 1
GROUP BY CASE WHEN BODY LIKE '%?%' OR Title Like '%?%' THEN 1 ELSE 0 END

Enter Parameters

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