--
-- ### Case when clause checks
--

create table t1 ( a int, b string(30));

insert into t1 values ( 1, 'xxx');
insert into t1 values ( 1, 'ggg');
insert into t1 values ( 4, 'yyy');
insert into t1 values ( 3, 'zzz');

select case when tx.a = 1 then 'alpha' else 'beta' end from t1 tx;
 
drop table t1;


