Make a Sql Query

Hello, I have this Query SELECT DoTes.Cd_DO, [login to view URL], [login to view URL] * [login to view URL] as TotMerceLordoV, [login to view URL], DoTes.Cd_CF, DOTes.Cd_VL, [login to view URL], [login to view URL], DOTes.Cd_Agente_1, DOTes.Cd_PG, [login to view URL] AS CF_Descrizione, [login to view URL], [login to view URL] FROM DOTes INNER JOIN VL ON DOTes.Cd_VL = VL.Cd_VL INNER JOIN CF ON DOTes.Cd_CF = CF.Cd_CF LEFT JOIN DOTotali ON DOTes.ID_DOTes = DoTotali.ID_DOTes WHERE(DOTes.Cd_MGEsercizio LIKE '2020%') ORDER BY [login to view URL] DESC That i need to modify so: SELECT DoTes.Cd_DO, [login to view URL], [login to view URL] * [login to view URL] as TotMerceLordoV, SUM(([login to view URL]*[login to view URL])*[login to view URL]) as Costo, [login to view URL], DoTes.Cd_CF, DOTes.Cd_VL, [login to view URL], [login to view URL], DOTes.Cd_Agente_1, DOTes.Cd_PG, [login to view URL] AS CF_Descrizione, [login to view URL], [login to view URL] FROM DOTes INNER JOIN VL ON DOTes.Cd_VL = VL.Cd_VL INNER JOIN CF ON DOTes.Cd_CF = CF.Cd_CF LEFT JOIN DOTotali ON DOTes.ID_DOTes = DoTotali.ID_DOTes WHERE(DOTes.Cd_MGEsercizio LIKE '2020%') ORDER BY [login to view URL] DESC but as you can see is not correct and it doesnt' working This part added SUM(([login to view URL]*[login to view URL])*[login to view URL]) as Costo, you have to adapt. I got this here (where it working) Select AR.Cd_AR,[login to view URL],[login to view URL], sum([login to view URL]*[login to view URL]) as Qta, sum([login to view URL]*[login to view URL]) as Valore, sum(([login to view URL]*[login to view URL])*[login to view URL]) as Costo from AR inner join DORig on AR.Cd_AR=DORig.Cd_AR inner join DO on DO.Cd_DO=DORig.Cd_DO where DO.CliFor='C' and [login to view URL]<>0 and [login to view URL] between '01-01-2020' and '10-01-2020' AND isnumeric([login to view URL]) = 1 Group by AR.Cd_AR, [login to view URL], [login to view URL], [login to view URL] UNION ALL Select AR.Cd_AR,[login to view URL], [login to view URL], sum([login to view URL]) as Qta, sum([login to view URL]) as Valore, [login to view URL] as Costo from AR inner join VbSconR on AR.Cd_AR=VbSconR.Cd_AR inner join VbSconT on VbSconT.Id_VbSconT=VbSconR.Id_VbSconT where [login to view URL] between '01-01-2020' and '10-01-2020' AND isnumeric([login to view URL]) = 1 AND [login to view URL]<>NULL AND [login to view URL]<99999 Group by AR.Cd_AR, [login to view URL], [login to view URL], [login to view URL] Order by Valore DESC If you are skilled in ms sql, you are able to understand the db structure looking the query above and fix mine as required. Thank you