Thanks, Paul! This is much appreciated.
Under CE130 you will get C^1/2 when statistics are not available, and you disabled auto create statistics. That's basically the estimate for equality with optimize for unknown...
Thanks, Dima! Code fixed.
Thanks for the feedback, gmgoutam!
This cannot be written as a single CASE expression. Three separate expressions are needed because the query generates three result columns.