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.
Which version of SQL Server are you using and what is the compatibility mode of the database? The VALUES clause was added in SQL Server 2008.