GTM Buddy Interview Question

sql question using joins and group by