instruction: Good answer vs includes code.
response: SELECT CASE WHEN a.Score > 0 OR a.Id = q.AcceptedAnswerId THEN 'yes' ELSE 'no' END AS GoodAnswer, CASE WHEN q.Body LIKE '%<code>%' THEN 'yes' ELSE 'no' END AS IncludesCode, COUNT(*) AS Count FROM Posts AS q JOIN Posts AS a ON q.Id = a.ParentId WHERE q.PostTypeId = 1 AND a.PostTypeId = 2 AND q.ViewCount > 10 AND q.AnswerCount > 0 AND q.CreationDate > (SELECT MAX(CreationDate) FROM Posts) - 30 GROUP BY CASE WHEN a.Score > 0 OR a.Id = q.AcceptedAnswerId THEN 'yes' ELSE 'no' END, CASE WHEN q.Body LIKE '%<code>%' THEN 'yes' ELSE 'no' END ORDER BY CASE WHEN a.Score > 0 OR a.Id = q.AcceptedAnswerId THEN 'yes' ELSE 'no' END