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

select
  *
from (
  select
    r_name,
    rank() over (order by r_regionkey) as ran from region
) a
where
  r_name LIKE 'ASIA'