Trouble converting CASE statement SQL to Cake Query

[jimgwhit]

You can use as is with the db connection. PDO instance example: Count and group by