viewing paste Unknown #261 | MySQL

Posted on the
1 2 3 4 5

  (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`
Viewed 401 times, submitted by unknown.