07-02 SELECT change col name

AS

01

Use AS to display new names for the columns

change first_name and last_name to forename and surname 

select first_name AS forename, last_name AS surname
from employee;