# E051: Basic query specification

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

query I
SELECT A FROM TABLE_E051_01_01

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

query I
SELECT A FROM TABLE_E051_01_02 WHERE A = 1

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

query I
SELECT ALL A FROM TABLE_E051_01_03

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

query I
SELECT ALL A FROM TABLE_E051_01_04 WHERE A = 1
