# E061-03: IN predicate with list of values

statement ok
CREATE TABLE TABLE_E061_03_01_01 ( ID INT PRIMARY KEY, A INT );

query I
SELECT A FROM TABLE_E061_03_01_01 WHERE A IN ( 1 )

statement ok
CREATE TABLE TABLE_E061_03_01_02 ( ID INT PRIMARY KEY, A INT );

query I
SELECT A FROM TABLE_E061_03_01_02 WHERE A IN ( 1, 2 )

statement ok
CREATE TABLE TABLE_E061_03_01_03 ( ID INT PRIMARY KEY, A INT );

query I
SELECT A FROM TABLE_E061_03_01_03 WHERE A NOT IN ( 1 )

statement ok
CREATE TABLE TABLE_E061_03_01_04 ( ID INT PRIMARY KEY, A INT );

query I
SELECT A FROM TABLE_E061_03_01_04 WHERE A NOT IN ( 1, 2 )
