sql-tests.testcases.order_by.orderByNonProjectedAggregate.sql Maven / Gradle / Ivy
-- database: presto; groups: orderby, limit
select avg(retailprice), mfgr from tpch.tiny.part group by 2 order by count(*) limit 20
-- database: presto; groups: orderby, limit
select avg(retailprice), mfgr from tpch.tiny.part group by 2 order by count(*) limit 20