SELECT COALESCE(picture, forename, 'friend') AS profile
  FROM member;