Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Japanese language
SELECT TOP 500
COUNT(QuestionId) AS NumberOfTypos, QuestionId AS [Post Link]
WHEN ParentId IS NULL THEN id
END AS QuestionId
REPLACE(LOWER(title), 'buffett', '') LIKE '%buffet%'
OR REPLACE(LOWER(body), 'buffett', '') LIKE '%buffet%'
GROUP BY QuestionId
ORDER BY COUNT(QuestionId) DESC