World cup - eigth-final 2014 question?

Hi All,

I can see a way of answering the worldcup eigth-final 2014 question using a union statement, but as we haven’t really talked about them yet, I’m wondering if there is another way Im missing using simple joins??

No clues wanted, just simple yes/no if union selects is the expectation


The tests are only checking the output there. It doesn’t matter how you get there, as long as the output matches what is expected.

I don’t think union is what was intended to be used there. It wasn’t taught in the courses leading up to that project if I recall - but if it works, go for it.

Yup I realise, I have a working solution, just wanted to make sure I havent missed something more obvious really…

I shall scratch my head a while longer