Loading collection data...
Collections are a way for you to organize kata so that you can create your own training routines. Every collection you create is public and automatically sharable with other warriors. After you have added a few kata to a collection you and others can train on the kata contained within the collection.
Get started now by creating a new collection.
Wow! Amazing... I like your explanation. please take note of the line FROM the databgase "people" it should be FROM the table "people"
nice strategy :D
Because I'm used to writing table names in all caps, but it would have probably been better using the same conventions as the author. Cheers
Looks great!
Not sure why you used all caps in your resultant table.
This comment is hidden because it contains spoiler information about the solution
It seems to me that both the tests and the submission don't check for the requirement, resulting table should be ordered by average salary descending.
I would want to see zero if there were a "name" and "id" without toys...
It depends on the question: in this instance, I feel the prompt wants a count for every name on the list.
As compared to only including names that indeed have a "toy_count" > 0.
This is certainly not the worst solution, but it isn't the best either.
It's easier for me to read your code if there are line breaks, at the very least, after commas.
In addition being explicit by using "AS" helps.
Also...where's your semi-colon?
I like that you left us your notes.
The actual code formatting and line breaks could be better.