Phenom Interview Question

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