1. The HR department wants a query to display the last name, job code, hire date, and employee number for each employee, with employee number appearing first. Provide an alias STARTDATE for the HIRE_DATE column.
2.The HR department needs a query to displa
1. WAQ to show <employee last name> earns <salary> monthly but wants <3 times salary.>. Label the column Dream Salaries.
2.Display each employees last name, hire date, and salary review date, which is the first Monday after six months of service. Label th
1.The HR department needs a report of all employees. Write a query to display the last name, department number, and department name for all the employees.
select e.last_name,d.department_id,d.department_name from employees e join departments d on(e.dep