Get posts containing a specific keyword
Get a listing of all posts grouped by year.
Get the top 5 wordiest posts by character count.
Find how many comments each user has across all of their posts.

Stuck on 4 -- making slow progress but too slow to complete tonight, startinging to make more sense though.