framework/resources/Functional/limit0/filters/plan/q4.sql

explain plan for select * from (
-- simple predicate on a groupping column
select x, y, z from ( select a1, b1, avg(a1) from t1_v t1 group by a1, b1 ) as sq(x, y, z) where x between 100 and 1) t limit 0;