SELECT forename AS firstname, surname AS lastname 
  FROM member;