|
Re: Jaci's Annual FRC Datadump 2016
I think there is a problem with jvriezen's SQL to get the max sum of team numbers on an alliance. I can't find a match where the 3 teams 6204|6191|6212 are on the same alliance. Here is my approach to answering this question:
select m.match, m.alliance_color, sum(m.team) as team_number_total from match_teams m group by m.match, m.alliance_color order by sum(m.team) desc
It gives a descending order list with the winner being match 5986, blue alliance, team total 18483 (which agrees with Ether's answer).
Last edited by antman : 13-05-2016 at 16:05.
|