Q&A for professional and enthusiast programmers
SELECT CAST(CHARINDEX('?', Title) AS BIT) AS HasQuestionMark, AVG(CAST(Score AS FLOAT)) AS AverageScore FROM Posts WHERE PostTypeId = 1 AND Score < 50 GROUP BY CAST(CHARINDEX('?', Title) AS BIT)