# E061-01: Comparison predicate

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

query I
SELECT A FROM TABLE_E061_01_01_01 WHERE A < 1

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

query I
SELECT A FROM TABLE_E061_01_01_02 WHERE A <= 1

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

query I
SELECT A FROM TABLE_E061_01_01_03 WHERE A <> 1

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

query I
SELECT A FROM TABLE_E061_01_01_04 WHERE A = 1

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

query I
SELECT A FROM TABLE_E061_01_01_05 WHERE A > 1

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

query I
SELECT A FROM TABLE_E061_01_01_06 WHERE A >= 1

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

query I
SELECT ALL A FROM TABLE_E061_01_01_07 WHERE A < 1

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

query I
SELECT ALL A FROM TABLE_E061_01_01_08 WHERE A <= 1

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

query I
SELECT ALL A FROM TABLE_E061_01_01_09 WHERE A <> 1

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

query I
SELECT ALL A FROM TABLE_E061_01_01_10 WHERE A = 1

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

query I
SELECT ALL A FROM TABLE_E061_01_01_11 WHERE A > 1

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

query I
SELECT ALL A FROM TABLE_E061_01_01_12 WHERE A >= 1

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

query I
SELECT DISTINCT A FROM TABLE_E061_01_01_13 WHERE A < 1

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

query I
SELECT DISTINCT A FROM TABLE_E061_01_01_14 WHERE A <= 1

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

query I
SELECT DISTINCT A FROM TABLE_E061_01_01_15 WHERE A <> 1

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

query I
SELECT DISTINCT A FROM TABLE_E061_01_01_16 WHERE A = 1

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

query I
SELECT DISTINCT A FROM TABLE_E061_01_01_17 WHERE A > 1

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

query I
SELECT DISTINCT A FROM TABLE_E061_01_01_18 WHERE A >= 1
