Writing "categories left join posts" instead of "categories join posts" worked for me.

i did something similar at the beginning to account for mr. mrs. miss. md . phd. sr. and all that, but for some reason the code still works without taking into account these things. in this specific code you just need to take into account the two variants i.e. first-name last-name and last-name, first-name

Encountered the same problem, using right join fixed it.

How does this pass having suffices in the name like "Mr." or "Mrs."?

Bubblies and yummies!

This solution is rather not consistent. Can anyone tell me why?

I am trying to solve this using row_number window function. However, I cannot get the null row.

Can anyone give me some hint as to how to return the null category? I am always getting 18 result

I dont really understand the third line, why are we dividing the 100, not mutiplying?