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?

ive been working through all the SQL things after reading on SQL from sql bolt. this short hand is very confusing. also what do you write people P......toys t?

No, you don't have to use join on a particular column. In fact, most of the solutions on here are what I would call bad practices in that they actually require data from the toys table to complete. You should really just do a count(1) so that when the join is happening underneath it could just use the index to get to the answer instead of requiring a table lookup for the value.

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.

yes it all changed and your points were updated according to the new "rules". But this calculation only happens when you connect yourself after the change. So your friend's scores are still the old one if they did not come back here.

What happened with the honor points?
Were the points per kyu level changed?

I used to have much less points if I recall correctly, and someone in my group was neck & neck with me, now my points are in the 800's and 2x theirs. I think we used to be in the 100's. What's up with this change? It seems to be rampant looking through the posts in here, and there's nothing communicated on the blog since about a year ago.

Spot on. Looks like others got this right.

Very interesting how you reverse at the end. I tried something like this but didn't have my reverse inside of the forEach so I had to verify I still had an array left to work with or it would throw an error.