add and split results in the same query by taking the result of the first sum

Question

I need two information I make the first sum

SELECT 
FORMAT(ROUND(SUM(CASE WHEN MONTH(periodo) IN (12) AND classificacao = '3.6' THEN IFNULL(debito-credito,NULL)  ELSE  0 END)) ,2) AS custo_1, 

Right below I need to take the result above and divide by another SUM

FORMAT(ROUND(SUM(CASE WHEN MONTH(periodo) IN (1)  AND classificacao = '3.6' THEN IFNULL(debito-credito,NULL)  ELSE  0 END)) ,2) 
/
FORMAT(ROUND(SUM(CASE WHEN MONTH(periodo) IN (1)  AND classificacao = '3.1.01.01' THEN IFNULL(debito-credito,NULL)  ELSE  0 END)) - ROUND(SUM(CASE WHEN MONTH(periodo) IN (1)  AND classificacao = '3.2.01.01.01' THEN IFNULL(debito-credito,NULL)  ELSE  0 END)),2)  AS peso_custo_1

FROM tbl_balancete;

How can I use the result of the first sum so I don’t need to use any cost sum code again ?

Answer 1

Try using a subselect:

Select Sum(Tabela.campoN+retSql.PrimeiraSoma) 
  From (select suatabela.periodo AS PrimeiraSoma
             , suatabela.classificacao
          from suatabela
       ) AS retSql
 Inner Join Tabela ON Tabela.classificacao = retSqsl.classificacao

This way, you can do only 1 select with the first value (you don’t even need to sum in) to be able to take advantage of any other piece of the query. Here add the sort field only to make Join with the 'external' table only to exemplify, Join has to be done with the corresponding field. I hope I’ve helped.