Understanding Common Table Expressions with FizzBuzz

Author here, what are some of your favorite uses of common table expressions?