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.
I think this kata is nice. However, some additional tests are required.
For example if I use the following code:
SELECT name, author, copies_sold FROM books WHERE copies_sold > 2000;
It actually passes all the 7 tests as for January 2024. Just adding a test with a couple of lower numbers than 2000 (let's say we have a less successful bookstore and the maximum amount of books sold per author will be let's say 100.) In this case the code above won't work.
This comment is hidden because it contains spoiler information about the solution
good job!
hahaha 4 countries in table ,got issue
Read the description 30 times
Not the Best Practices definatly
The description is really funny in this kata.
Thanks for the kata.
I have noticed that there is a small typo in " You have a list of all students, some of them have already paid tution and some haven't" tution should be tuition.
This is easy, but sometimes we forget about semicolons in SQL, good exercise
This comment is hidden because it contains spoiler information about the solution
I was stumped for a few minutes before I realized that this excercise is case sensitive.
I think having a limited view of the table would make this much simpler
The wording of this kata is so confusing andmakes it harder than it actually is.
It works, but the description for this task is too vague, it's unclear how the outcome should look like.
You need to finish first (INSERT INTO) query with ; and then follow it with second query: SELECT * FROM participants;
why won't using INSERT into participants Values (value1,value2,value3) work....
Loading more items...