otherwise the max() would not work, it requires to have all columns we "select" considered

poorly written description on their part!

it's never suggested that we should return for each name so i assumed we should do a window count... it's never stated we should group by each name..come on

i thought he was asking it to BE the length of the string (length of the column be the same as the length of the column to the right). He meant the column's VALUE should be the length of the column to the right

thank you for this recomendation it was extremely helpful

if i showed you my code (that worked), you might think i am actually mental :D took me a few hours and feels like very cpu intensive and a lot of potentially unnecessary logic..but it worked in the end

why group by credit_limit?

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

i responded with a different function. i am not sure why the replace function is not working