Luis --

Since you want to Group by Conta, you need that logic in your GROUP BY clause. I would rewrite your query as:

SELECT

case

...