[Solved]1 Create Run Sql Query Return Display First Names Email Last Names Job Identifications Emp Q37280195

1. Create and run an SQL query that will return/display thefirst names, email, last names and job identifications of employeesfrom the EMPLOYEES table and the department identifications anddepartment name from the DEPARTMENTS table.

SELECT first_name, email, last_name, job_id,

(SELECT department_name FROM departments d

WHERE e.department_id = d.department_id) department

FROM employees e ORDER BY department;

2. Based on your SQL statement above, do you need toqualify/prefix any of the column names in the SELECT statement? Ifso, which column names do you have to qualify/prefix. For anycolumns that you don’t need to qualify/prefix, why don’t you haveto?

3. This problem will involve a three-way join using three tablesin our database. Write an SQL query to retrieve/display theemployee identifications, cities, department name, manageridentifications, and location identifications.

4. Rewrite your SQL statement above (for #3) to get the exactsame result but with using different SQL keywords (your SELECTstatement can remain the same).

Expert Answer

---

Answer to 1. Create and run an SQL query that will return/display the first names, email, last names and job identifications of em… . . .