# Test subquery

statement ok
create table t(id int primary key, a int not null, b int not null);

statement ok
insert into t values (0, 1, 2), (1, 3, 4);

query II
select a, b from (select a, b from t);
----
1 2
3 4

query II
select x.a, x.b from (select a, b from t) as x;
----
1 2
3 4

query II
select * from (select a, b from t);
----
1 2
3 4

query I
select s from (select a + b as s from t);
----
3
7