Loading collection data...
Collections are a way for you to organize kata so that you can create your own training routines. Every collection you create is public and automatically sharable with other warriors. After you have added a few kata to a collection you and others can train on the kata contained within the collection.
Get started now by creating a new collection.
Got it, so that clears things up! Thank you.
i'm not sure how this solution passed the tests at some point, but it does not pass them anymore. you can try copying and pasting it into the trainer, it fails the tests every time
approved
With the following solution, there is no multiplication or other modification of the strength.
https://www.codewars.com/kata/reviews/5ab82b176b888f236900626c/groups/6252b43bc522ea0001d70a69
How can it be that this solution has passed?
Do I not see the key to the solution or are the tests set up in such a way that it also passes with these values?
Is the multiplication possibly not even expected?
If I repeat the above "attempt" to log the data for Ryu until I get a dataset that has Ryu in the expected top 6, the expected result for Ryu is: 42 wins, 11 losses, and his fight records are:
--> Here, there are 17 records with lost= 0, but only 11 are actually expected. So now we would need to exclude 6 fight records with lost= 0.
However, of those 17, 7 have won= 1, and 10 have won= 2, which does not leave any way to proceed other than assuming lost= 1 would possibly mark a LOSS (which the description has ruled out).
#########################
I would consider this an ISSUE, but I cannot edit the label here...
Logging the countable results of one fighter in an "Attempt" with:
SELECT * FROM fighters WHERE name='Ryu' AND move_id> 3 ORDER BY lost;
results in:
The expected result for Ryu in this attempt is: Ryu wins: 43, Ryu lost: 14.
From this we can assume that all lost= 0 recordings mark a LOSS, and that won= 2 is not a DRAW, but a WIN with special points that have to be accounted for in the query. But if so, how would we arrive at 43?
As won= 1 has been declared as a regular win and lost= 0 seems to be counted as 1, it seems fair to think those five results with won= 1 should be counted as 1 each. That would mean the 9 won= 2 records had to be multiplied with some factor, but 43- 5= 38, and 38/ 9= 4,2222, which would be a bit odd. Are the data just broken here?
I love this kata, especially its LOTR part
Hello I'm a beginner so this sentence made me confused:
'Practise some SQL fundamentals by making a simple database on a topic you feel familiar with. Or use mine, populated with a wealth of Sailor Moon trivia.'
I tapped query: 'create database dog;' thinking I have a task to make database on a topic that im familiar with. But this was not at all the assignment.
Please make assignment more clear by deleting mentioned above sentence.
THANK YOU- This solved the issue I was having!
return schema added to description, please approve
https://www.codewars.com/kumite/666d6130ac89e9b1857a3ddd?sel=666d6130ac89e9b1857a3ddd
The problem description is quiet vague for me.
this was fun, had me confused with the amount of records returned for a second (was using inner join instead of left)
Nice kata
Please use the appropriate tag (Use
issue
andsuggestion
tags only if there is something wrong / to improve the kata itself) and refrain from posting working solutions in the discourse.Thank you 😃.
This comment is hidden because it contains spoiler information about the solution
Loading more items...