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
© 2015 - 2024 Weber Informatics LLC | Privacy Policy