当我们在联接中使用聚合函数时如何使用Group By子句？

I want to join three tables and to calculate the Sum(Quantity) of the Table A. I tried something and I get the desired output. But still I have confusion based on aggregate function and Group By clause.I want to join three tables and to calculate th