tajo-storage/tajo-storage-kafka/src/test/resources/queries/TestKafkaQuery/testGroupby.sql

select id, count(*) from prod group by id order by id;