SELECT DISTINCT AccountOwnerId, Account_name, Meter_name, SUM(Consumed_Quantity) AS Sum_time, Unit_of_measure, Month FROM Azure WHERE Meter_name='Compute hours' Group by accountownerid, account_name, meter_name, unit_of_measure, month Order by Sum_time desc;