Many people understand SQL's CASE WHEN as a syntax for "applying labels based on conditions." While that is certainly a correct usage, there are several other effective patterns in practice. This ...