SELECT Service_Name, Price, SUM(Qty) AS Qty, SUM(Value) AS Value, Ident FROM NewOne GROUP BY Service_Name, Price, Ident ORDER BY Ident ASC