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

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