Domanda di colloquio di Phenom

Two table join and then grouping with example dataset to write pseudo query.