GTM Buddy interview question

sql question using joins and group by