SELECT DISTINCT (SELECT `player_name`) as pname, (SELECT SUM(amount) FROM `table` WHERE `player_name`=pname && `damage_type`='Heal'), (SELECT SUM(amount) FROM `table` WHERE `player_name`=pname && `damage_type`='Damage') FROM `table`