SELECT NAME AS "Employee Name" FROM PEOPLE; SELECT p.NAME AS "Employee Name", s.SALARY FROM PEOPLE p JOIN SALARIES s ON p.ID = s.ID;