We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
While that yields a correct-ish result, a couple of critiques:
The spec didn't call for concatenation in the result set, so technically this didn't meet the requirement - but the test let you squeak by.
Avoid expressing filtering conditions in JOIN predicate. JOIN predicate should involve key columns only. (Use WHERE to filter for full scores only. score is not a key in Submissions.)
Alternative solution, a bit more straightforward & easier to read:
Top Competitors
You are viewing a single comment's thread. Return to all comments →
While that yields a correct-ish result, a couple of critiques:
Alternative solution, a bit more straightforward & easier to read: