tajo-core-tests/src/test/resources/queries/TestTablePartitions/case12.sql

select
    key as key_alias,
    count(*) cnt
from
    testQueryCasesOnColumnPartitionedTable
group by key_alias
order by key_alias desc