framework/resources/Functional/semijoin/semiJoinFilterOthers5.sql

set `planner.enable_semijoin` = true;
select orders.o_totalprice from orders where orders.o_custkey in (select customer.c_custkey from customer where c_acctbal > 2503) and orders.o_totalprice > 85000 order by orders.o_totalprice limit 10;
reset `planner.enable_semijoin`;