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 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
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?
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
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.
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.
Loading more items...