试图在SQL Server中进行Sum（MAX）计算

Thanks for all the help that you all provided and though it was an eye opener unfortunately it did not produce the expected results I was looking for. In an effort to better get the help I'm looking for I will try to explain what I'm looking to achieve.Thanks for all the help that you all provided a