Question: Employees ( emp _ id , name, hire _ date, job _ id , salary, comm, manager _ id , dept _ id ) Departments
Employeesempid name, hiredate, jobid salary, comm, managerid deptid Departmentsdeptid deptname, managerid location id Locationlocationid street, postcode, 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
