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