This tip shows how powerful the CASE expression is, and some of the nuances in its behavior.