Thanks!

Seems like some sort of a platform issue. It has nothing to do with the kata itself.

Me neither but I'm glad it's working for you now. The kata hasn't been changed a bit so most likely it was an issue with the platform.

I don't see any problems with the kata. I just copied and pasted the code you showed character to character and it passes all the tests with flying colors.

Just ran your query and it passed with flying colors.

Thanks for trying the kata. Post your query and mark as a spoiler. Also post exact error you're getting when you run it.

Thanks! Actually this is intentional and is a part of the challenge. It forces you to realize exactly that and reach out for proper and often underutilized SQL facilities in PostgreSQL. In the real world though I totaly agree there should be a proper key in each table.

Hope this makes sense.

Thanks again for trying this kata.

I'd suggest changing column names of the expected result set or using separate columns for titles and suffixes like @RLOG89 suggested. Let me explain "first name" and "second name" have a very specific meaning in English language. "Jr." in "Greyson Tate Lebsack Jr." is not a second name, as well as "Clementina" in "Elmore Clementina O'Conner" is not a first name on its own. Besides a more detailed explanaition of the logic of splitting the names into parts would be much appriciated.

Hope this makes sense.

You're very welcome! :) Thanks for trying it out.

Thanks!

Good catch! Thanks. It fixed now.

Is there any particular reason why this translation is not being accepted or at least discussed? Thanks.

Is there any particular reason why this translation is not being accepted or at least discussed? Thanks.

@jhoffner Hi! Is there any particular reason why this and other translations to this kata are not being accepted or rejected?

Thanks for the kata!
Unfortunately right now it's impossible to use 'Run examples' which is very confusing. In order to fix this consider properly preloading the data ("Preloaded" tab) and providing if not a full then at least a decent set of so called example tests ("Example Test Cases" tab) so that people can work in a TDD manner on a solution.