Question: Employees ( emp _ id , name, hire _ date, job _ id , salary, comm, manager _ id , dept _ id ) Departments

Employees(emp_id, name, hire_date, job_id, salary, comm, manager_id, dept_id) Departments(dept_id, dept_name, manager_id, location id) Location(location_id, street, post_code, city, state, country) Write an SQL query to answer the following statements: i). Display the department number, name, job, and department name for all employees in the CSE department. ii). Write a query to display the employee name and hire date for all employees in the same department as Mr. X. iii). Write a query to display the employee number, name, and job title for all employees whose salary is more than an average salary of any department.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!