tajo-core/src/test/resources/queries/TestWindowQuery/testWindowWithAggregation6.sql

select
  l_orderkey,
  count(*) as cnt,
  row_number() over (order by count(*) desc) row_num
from
  lineitem
group by
  l_orderkey
order by
  l_orderkey;