SELECT Nickname FROM friends WHERE Name.First='John'