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