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 participants in team and individual sport activities
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?