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.
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.
Agree, it must be LEFT JOIN (in case of 'people LEFT JOIN toys) when there may be people who don't have any toys. The dataset is wrong and can lead to bad solution that fits this particular dataset but not general case.
This comment is hidden because it contains spoiler information about the solution
Spot on. Looks like others got this right.