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

explain plan for select * from (
-- like predicate
select x, y, z from ( select a1, b1, avg(a1) from t1_v t1 group by a1, b1 ) as sq(x, y, z) where y like '%b%') t limit 0;