SELECT "a"."nrobl", "a"."idbls", "a"."freight_terms", "a"."documents", "a"."unidad_flete", "a"."valor_isps", sum(CAST(a.surcharge AS float)) as surcharge, COUNT(DISTINCT contenedor ) AS cnt_cont, sum(CAST(a.ocean_freight AS float)) as ocean_freight, sum(a.pallet_emb) as pallet_emb, sum(CAST(a.isps AS float)) as isps, sum(CAST(a.baf AS float)) as baf, sum(CAST(a.thc AS float)) as thc, count("nrobl") as cntbl, sum(CAST(a.pcs AS float)) as pcs, sum(CAST(a.valor_unit AS float)) as valor_unit, Sum(CAST(a.gate_out AS float)) as gate_out, Sum(CAST(a.valor_baf AS float)) as valor_baf, Sum(CAST(a.acontrolada AS float)) as acontrolada, Sum(CAST(a.bl_fee AS float)) as bl_fee, Sum(CAST(a.dthc AS float)) as dthct, Sum(CAST(a.dthctotal AS float)) as dthctotal, "a"."dthc", Sum(CAST(a.inland AS float)) as inland FROM "lf_fletevalorizacion" "a" WHERE "a"."idviaje" = '90' AND "a"."idbls" = '2565' GROUP BY "a"."nrobl", "a"."idbls", "a"."freight_terms", "a"."documents", "a"."unidad_flete", "a"."valor_isps", "a"."dthc"