framework/resources/Functional/group_by_alias/group_by_order_by_index_and_alias.sql

select intField i, count(intField) ci, strField s, count(strField) cs from dfs.drillTestDir.`DRILL-1248/group_by_parquet` group by 1, 3 order by 1, ci;