EY Interview Question

some SQL problem that examined knowledge about the JOIN function