Q&A for professional and enthusiast programmers
DECLARE @FirstWords TABLE (Word NVARCHAR(250)) INSERT @FirstWords SELECT Substring(Title, 1, CharIndex(' ', Title)) FROM Posts WHERE PostTypeId = 1 SELECT TOP 100 Word, Count(*) AS [Count] FROM @FirstWords GROUP BY Word ORDER BY Count(*) DESC