select * from t1 where a = 42 or a = 1 and  b = 'X' ;
select * from t1 where a = 1 and  b = 'X' or a = 42;
select * from t1 where a = 42 or ( a = 1 and  b = 'X' );

drop if exists table t1;
create table t1 (
    a int,
    b int,
    c int);

insert into t1 values ( 1, 1, 10 );
insert into t1 values ( 1, 2, 20 );
insert into t1 values ( 2, 1, 5 );
insert into t1 values ( 2, 2, 42 );
insert into t1 values ( 2, 3, 42 );
insert into t1 values ( 3, 1, 1 );
insert into t1 values ( 3, 2, 65 );
insert into t1 values ( 3, 2, 12 );

drop if exists view v1;
create view v1 as
select
    a as a,
    b as b,
    sum ( c) as csum
from t1 group by a, b;

select a, b, csum from v1 where a = 3 and b = 2;

-- csum cannot not be evaluated in the view condition
-- cursor must perform a dedicated evaluation
select a, b, csum from v1 where a = 3 and b = 2 and csum = 77;