Joining Tables with Recent Date for Each Row Then Weighted Averaging

Calculating Mean, Standard Deviation, and Counts in a Single Record Using Conditional Aggregation for High Performance