tajo-core-tests/src/test/resources/queries/TestTableSubQuery/testGroupBySubQuery.sql

select sum(l_extendedprice * l_discount) as revenue from (select * from lineitem) as l;