I think of this mostly in SQL… and that would be `group by sport` and for all of the other columns, each would need to be replaced with some aggregation function: min, max, avg, array_agg, kurtosis! https://docs.snowflake.com/en/sql-reference/functions-aggregation
Ahh yeah of course! Right. That makes sense. I feel like, because I don't have a good vocabulary for the different possible shapes of a grouping, I don't think very clearly about them. Like I know how to do it in JavaScript and I know how to do it in SQL but I'm sorta doing it by rote in SQL and it did not occur to me while writing this that it's how SQL works.