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.
If I am not wrong, this is the best practice because of the following reasons:
Maybe for this particular case, using '*' after the keyword 'SELECT' could lead to the same result, but I think it is good to develop the habit of just fetching the required columns by using their names and thus avoiding the possible fetching of unnecessary or sensible data.
walk in the park
I need to read one more time to understand why Mexicans and Canadias are not Americans. WTF :D America is the whole continent.
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
Loading more items...