create queries with calculated fields and aggregate functions