使用mybatis我需要查询总量和平均.语句中多次写到 sum(a),sum(a)/${days},sum(b),sum(b)/${days}这样计算两次相同的sum会不会很浪费资源。有什么办法只sum一次么。我试过 sum(a) as asum,asum/${days}结果报错Unknown column 'asum' in 'field list'
子查询select t.asum/$(days) from (select sum(a) as asum) t