Athena Presto: Transforming Data from Long to Wide with Conditional Aggregation

Using Multiple Columns per Reference ID in SQL with Window Functions and Aggregation