Finding the use of the word 'Cthulhu' in tags on Stack Overflow
select t.TagName, count (*) 'Tainted'
  from Posts p
 inner join PostTags pt on (pt.PostId == p.Id)
 inner join Tags t on (t.Id == pt.TagId)
 where lower(p.Body) like '%cthulhu%'
 group by t.TagName
 order by Tainted desc, t.TagName asc



Notice the lower on the body, because like is (should?) be case sensitive.
The joins are also easier to read IMHO than the conditions in the where clause.
The formatting is based on right-aligning keywords and left-aligning clauses.