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