you can't 'CASE ... WHEN ...' the from, where clauses in a SQL. try using some others... perhaps like following :

select <col1>, <col2>....

from < all where, group by...