I only miss one little detail from the description. At a beginner level it's not evident how to separete an insert from a select after it (not even evident it has to be separated to be precise). As it's a must to leave the select there, could you please add a half row to the description stating that we have to use a ";" to separete commands? Thanks :)
Good kata for novice at SQL! Thanks for creating this!!
Nice kata! I recommend adding the example tests to the main test cases. My first solution passed the test cases on Attempt, while failing the example tests.
No problem! - I'm happy I wasn't crazy :)
LIMIT is not standard, and shouldn't be used. FETCH FIRST (SQL2016) or doing a WHERE with subqueries is the way to go
You are right. Thanks for pointing this out! I'll fix it.
Am I nutty or are the columns reversed?
"name" has authors while "authors" has book titles?
I'm at 5 kyu, but this is the first "insert" kata I've come across. Thanks for widening the skill pool!
The SQL LIKE operator is only applied on a field of types CHAR or VARCHAR
This comment is hidden because it contains spoiler information about the solution
I've submitted a fork here: https://www.codewars.com/kumite/5ac58e3f348c228eaf0000b5?sel=5b64a34a07a2664f980000e1
Still the same; as far as I know, it can only be resolved by forking.
Can you please try again? There was a problem with the tests, and I fixed it.
Merge conflict, probably because of the kata rank change, try forking the translation.