Group by - reference to other table

Im closing this due to lack of response. its hard to get any info around this forum for non programmer like me

Hi anyone, any insight on how can i manage this?