SQL Help

The problem I am having is that it show the first name on the table and not the one that the number is linked to.
Any help would be much appreciated.

try
Group by Name