• ###### lfaglianocommented on "Complementary DNA" sql solution

This comment is hidden because it contains spoiler information about the solution

• ###### CClairvoyantcommented on "SQL Basics: Top 10 customers by total payments amount" kata

Depends on what you compare. If indeed you compare it to 7 kyu fibonacci, then yeah, you aren't gonna use the exact code again. However fibonacci gives you knowledge of recursion and perhaps cacheing. Also, if you look at 3-4 kyu tasks, you notice some even make you program some part of a game.

• ###### felipesebbencommented on "Calculating Running Total" kata

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.

• ###### felipesebbencommented on "Is the string uppercase?" kata

That was a tricky one! Thank you for this kata, learned a lot!

• ###### Elimulocreated an issue for "Growth of a Population" kata

Hi people,
When I do the test I got an error message, but my results are exaclty the expected answers... do you know why?
I have: log 15 ! None should equal 15
and so on for all tests...

• ###### felipesebbencommented on "Growth of a Population" kata

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 **)"

• ###### felipesebbencommented on "SQL Statistics: MIN, MEDIAN, MAX" kata

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).

• ###### felipesebbencommented on "Detect Pangram" kata

Thank you for this kata. It was a nice way to see how other people have dealt with the challenge!

• ###### felipesebbencommented on "SQL Bug Fixing: Fix the JOIN" kata

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.

• ###### felipesebbencommented on "Disemvowel Trolls" kata

Good kata, thank you!

• ###### felipesebbencommented on "SQL Basics: Top 10 customers by total payments amount" kata

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!

• ###### felipesebbencommented on "Are You Playing Banjo?" python solution

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.

• ###### felipesebbencommented on "Calculating Batting Average" kata

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!

Thanks!