drop table if exists simple_test; create table simple_test ( val integer ) with structure = vectorwise; insert into simple_test values (1); select avg(cnt) from ( select count(val) cnt from simple_test ) a; \g