I solved it, but I'm not sure I get why it works. Shouldn't we have to account for the few cases where the ASCII code is only 2 digits? My solution definitely used the fact that most ASCII codes a 3 digits.
why is the 'b' not in the response, in the example?
this one is even more compact than i had predict.
why does semi colon trigger an error? I thought semi colon signified the end of a statement or query or whatever the correct term is ?
Think about rounding it as a different datatype, or try using ROUND() to round to an integer.
In what ways were the instructions misleading? Have they been fixed now? (I ask because I solved it by following the instructions and the output of the sample test: perhaps I misread the instructions.)
Yes, please add an instruction only to use postgres to the description, or switch off SQLite, as the error is still there.
How are you connecting those two tables in your query?
My code is:
WHERE EXISTS(SELECT *
I made a test on:
Just to check if all those rows didn´t had a department_id=6,just as needed for the solution.
It didn´t, so I went on test the main code, but for some reason the row with the id=6 is still being called.
kata already approved, no need to keep that issue opened
Thanks for this kata, I didn't know about this concept before!
very interesting kata, thank you
I wrote 21 lines and saw these :)
Shown on the eer-diagram in the kata description.