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