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

Creating Cross-Tables with Filtered Observations in R using dplyr and Base R