SELECT DISTINCT(CODE_PREFIX), CDC, COSTO_EQP, COSTO_SERVIZIO,
(SPP_COST * QTY_SPP) As COSTO_SPP, SUM(SPP_COST * QTY_SPP)...

that easy!