INDmoney interview question

Average SQL question on Joins groupby