4 ms·
Here is a single query to get you both solutions. https://pastebin.com/P7LN9jMz https://pastebin.com/P7LN9jMz This was after I solved it the old fashioned way
by sqldevuser 7y ago
Here is a single query to get you both solutions.
https://pastebin.com/P7LN9jMz https://pastebin.com/P7LN9jMz
This was after I solved it the old fashioned way though :)
- ticmasta 7y agoI thought you had created a single massive join to find the answer and was pre-impressed. This is fine in the strict "correct solution" answer but totally against the spirit, so boo!