MySQL Lead function returns NULL

I have this MySQL table:

MySql Lead function – Next row in single select statement

Imagine a MySql tablet with multiple columns, one of which is called Name.