Posts by teste1234 • 21 points
1 post
-
2
votes1
answer79
viewsQ: Sum subquerys values separately
I have a problem in this query below: select sum(tb1.l1) * 0.3, sum(tb2.l2) * 0.3 from ( select setor, total_geral as l1 from mobile.auditoria where month(data) = month(now()) and year(data) =…