Case with like operator

Question

I have a column called queue_name  with following values.

 

 

[Ads] [dddd] Polit Classification US - Ad	add level
[Ads] [dddd] Political Classification US - Ad	add level
[Ads] [Proactive] Political Classification US - Body (Dark Mode)	unknown

 

 if column has - Ad then status as 'add level' else 'unknown'

 

i tried it as follows.

 

select (case when queue_name like '%- Ad%' then "ADLEVEL" else "COMPLEVEL" end) FROM table

 

i got the following error.

 

Column 'adlevel' cannot be resolved