Hello I'm a beginner so this sentence made me confused:
'Practise some SQL fundamentals by making a simple database on a topic you feel familiar with. Or use mine, populated with a wealth of Sailor Moon trivia.'
I tapped query: 'create database dog;' thinking I have a task to make database on a topic that im familiar with. But this was not at all the assignment.

Please make assignment more clear by deleting mentioned above sentence.

THANK YOU- This solved the issue I was having!

return schema added to description, please approve
https://www.codewars.com/kumite/666d6130ac89e9b1857a3ddd?sel=666d6130ac89e9b1857a3ddd

The problem description is quiet vague for me.

this was fun, had me confused with the amount of records returned for a second (was using inner join instead of left)

Nice kata

Please use the appropriate tag (Use issue and suggestion tags only if there is something wrong / to improve the kata itself) and refrain from posting working solutions in the discourse.

Thank you 😃.

I like your attitude towards grumpy people!

When asking Google for help, make sure to also look up the SQL server you're using

dont know why everyone is ragging on this kata, I thought it was fine. The columns to merge on are a bit confusing I suppose.

Please change the description. I had to read the comments to solve this kata. It is poorly described!

need to sum not cound, wasted 30 minutes debuging, better read comments

A nice task for sure, but I'm running into issues when attempting to "Attempt" the Kata; the results that my code finds are returned in Alphabetical order whether I want them to be or not, yet the test cases don't have any order, this leads to me technically failing the Kata eventhough the correct number of rows and correct names are returned. Any help on this would be fab. :)

I could not understand what is wrong in my solution?
Can smbd help me? I even unblock the solutions by other to compare.
#SQL