MSSQL - Query to calculate Weighted Average (Like SumProduct in Excel)

watch this example on YOUTUBE


Select Sum(Cast (Col1 as float) * Cast(Col2 as float)) /Sum(Cast(Col1 as float))
From WeightAverage