instruction: Are posts better/more popular if they have a tag in their title?.
response: SELECT COUNT(*) AS Number, AVG(p.ViewCount) AS Views, ROUND(AVG(CAST(p.Score AS FLOAT)), 3) AS Score, ROUND(AVG(CAST(p.AnswerCount AS FLOAT)), 3) AS AnswerCount, CAST(AVG(CAST(p.CreationDate AS FLOAT)) AS DATETIME) AS AvgDate, CASE WHEN LOWER(p.Title) LIKE '%##TagName##%' THEN 'yes' ELSE 'no' END AS TagInTitle FROM Posts AS p INNER JOIN PostTags AS pt ON p.Id = pt.PostId INNER JOIN Tags AS t ON t.Id = pt.TagId WHERE p.PostTypeId = 1 AND t.TagName = '##TagName##' GROUP BY CASE WHEN LOWER(p.Title) LIKE '%##TagName##%' THEN 'yes' ELSE 'no' END