EY interview question

some SQL problem that examined knowledge about the JOIN function