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.
Thank you for this kata, it was a tough one but very instructional! Learned how to apply CTEs instead of casting a column a bunch of times.
That was a tricky one! Thank you for this kata, learned a lot!
Very good kata! After having failed one of the test, I realized that the answer was in this part of the instructions:
"(** number of inhabitants is an integer **)"
Thank you for this kata. It was a good lesson on how not to unnecessarily start joining tables and grouping results. As I thought, the answer was quite straightforward (with the obvious exception of the median calculation, which was a new thing to me).
Thank you for this kata. It was a nice way to see how other people have dealt with the challenge!
Thank you for this kata. It is always challenging to deal with float numbers and decimal points in POSTGRES. It took me a while to finally round the numbers while casting them as float types.
Good kata, thank you!
This is the kind of kata that I really like to solve. They look like real life challenges (well, I don't think I'll be finding the nth value of a fibonacci sequence anytime soon during work!). Thank you!
In this case, lower() will lower all first letters. It is a way to make words case insensitive, as all Rs will be converted to r, thus having no need to check for differences.
Veru good challenge. The instructions were clear and it was a good way to practice working with different dtypes and converting them accordingly. Thank you!
That was a very good kata! I would rank it as somewhat tougher than the average 7kyu ones.
Please review the description. It was very good until it missed some relevant details, such as requiring the output of the "price_per_kg" column to be converted to float. Otherwise, I liked the challenge.
that was a good kata! Went to a totally different way first.