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.
The second query is already written, the only thing you should do is complete the insert query.
I fail to see what's confusing there.
Bumping, because 3 years later it still hasn't been updated xD
Yes! It was a great refreser for the WHERE NOT for me too :)
WORST FORMULATION EVER.
Same here! it took me a day to realize I had a space within the ' hufflepuff' and was banging my head against the wall! :D I thought it was a problem of = or IN (' '), but not really.
This comment is hidden because it contains spoiler information about the solution
This comment is hidden because it contains spoiler information about the solution
This comment is hidden because it contains spoiler information about the solution
This comment is hidden because it contains spoiler information about the solution
I would suggest to update the Kata description to one where the output is a bit clearer. It is supposed to be for beginners and I saw a lot of comments of people struggling to understand that you need to insert AND show the resuts. Those are two queries and it can be confusing for someone just starting.But overall, it's good for practice.
I believe some of the katas I have trained on are missing some key information about the expected outcome.
Here's a bit tricky because it says just insert, but not show, which is what makes the difference between doing just one query, or two, which is what you need here.
This comment is hidden because it contains spoiler information about the solution
I dont' underestimae the power of this series of SQL for beginners for refreshing some basic but key concepts and syntaxis!
I find this series of SQL for beginners quite good for refreshing some fundamentals. Do not underestimate the power of simple exercises to remember basic but imporant concepts and syntaxis!
I actually loved it. It made me refresh my attention to detail.
Loading more items...