You can make it even funnier. create table from (select UInt8, where UInt8) engine = MergeTree() order by tuple(); insert into from values (1, 1), (2, 1),

You can make it even funnier. create table from (select UInt8, where UInt8) engine = MergeTree() order by tuple(); insert into from values (1, 1), (2, 1), (3, 0), (4, 0), (5, 1); select select from from where where; select select from from where where is a really lovely query.