Hi it passes all of my test but while submitting says the values should display NULL . The data in the table is empty.
I thought this could probably be considered a level 6 kyu, overall nice though, thanks.
Fun kata about Harry Potter.
I have reviewed some solutions and I found two type of select : * and explicit column names.
I prefer to write explicit columns to return because its possible to make modifications in the table and it's difficult to follow the impact in our code. What is your opinion?
i got confused with group by..................
nice kata! now i've known how to JOIN with more than 2 tables! thank you!
I didnt encounter any problem, either this was an issue with your code or something got changed since (but i dont see any recent revision)
Please re-open an issue if the problem persists :)
Kata enforces the use of NOT IN without mentioning don't use NOT LIKE. Additionally it frames the question as a COUNT of the wins/losses when this isn't the case
You are lying right?
The Kata would be a lot clearer if there was a schema with values given in the description.
Otherwise a very fun Kata!
When I execute TEST I pass the 8/8 test cases. However when I submit and select ATTEMPT, I sometimes pass 6/8 test cases or 7/8 of the test cases. What could be my error?
I have just noticed that I fogrot to sort the output. However, all the tests have passed.
the instructions seem to indicate that a loss is denoted by a zero, but it's really the opposite. counting losses is as simple as counting 1's. there are also a lot of 2's in the wins column...really the records in both columns are just counts rather than the binary system heavily implied by the wording. i started off counting 0's in the losses column as a result of my confusion. anyway, pretty simple problem...hardest part was decoding the expectations
Why won't my
SELECT TOP 6 work...only the LIMIT 6?
just because of the comments i understood that won or lost can be bigger than 1. should be defined a little more clearly, unless it is part of the kata that it is so cryptic.
Not a suggestion. Posting solutions is prohibited.