Untitled
public sql v1 · immutableSELECT 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;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;