framework/resources/Functional/limit0/filters/plan/q22.sql - drill-test-framework - Git at Google

 explain plan for select * from (
 -- can't push down filter: aggregate function
 select x, y, z from ( select min(t1.a1), max(t1.b1), avg(t1.a1) from t1_v t1, t2_v t2 where t1.c1 = t2.c2 group by t1.a1, t1.b1) as sq(x, y, z) where  y not like '%b%') t limit 0;
	explain plan for select * from (
	-- can't push down filter: aggregate function
	select x, y, z from ( select min(t1.a1), max(t1.b1), avg(t1.a1) from t1_v t1, t2_v t2 where t1.c1 = t2.c2 group by t1.a1, t1.b1) as sq(x, y, z) where y not like '%b%') t limit 0;