Most common "first word of question title" by year, comparing Average Score and Answer Count.
Note that "I Statements" are not good in this case! (Avg score is below zero even though it's a top-ten first word.)
Q&A for developers and end users of the Sitecore CMS and multichannel marketing software
and closeddate is null
rank() OVER (PARTITION BY yr ORDER BY count(*) desc) AS Rank,
group by firstWord, yr
order by count(*) desc, FirstWord;
UPPER(LEFT(firstWord,1))+LOWER(SUBSTRING(firstWord,2,LEN(firstWord))) [1st Word],
avg_score [Avg Score],
avg_num_answers [Avg #Answers]
order by yr, rank, firstWord
-- yearsBack: How many years back (before this year) to include?