Use a join to display the employee identification number, employee name, job des
ID: 3908635 • Letter: U
Question
Use a join to display the employee identification number, employee name, job description and department name of all employees of the SALES department. Use a subquery to display employee identification number, employee name, job description and department name of all employees of the SALES department. Use a subquery to display the details of the employees who have been hired after the employee JONES was hired. Use a subquery to display the employee name, job description, and salary of all employees who have the same job title as you (E.g. the employee you created with your name). Display the average, maximum, and minimum salary of all the employees. For each department, display the department number, the average, maximum, and minimum salary earned by the employees of the department. Sort the data by maximum salary. 1. 2. 3. 4. 5. 6.Explanation / Answer
Q1. Join query to display employee identification number, employee name, job desciption, department_name of all employees in SALES department.
Answer)
select employees.employee_id, employees.employee_name, employees.job_description, departments.department_name from employees inner join departments on departments.department_id=employees.department_id where departments.department_name='SALES';
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.