SELECT team_id, data_type, SUM(value) FROM
 players INNER JOIN  match_data ON (match_data.player_id = players.id) WHERE players.id IN(select player_id from match_data where match_id = 7) GROUP BY team_id;