Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Concepts

Authors: David M. Kroenke, David J. Auer

7th edition

133544621, 133544626, 0-13-354462-1, 978-0133544626

More Books

Students also viewed these Databases questions

Question

u = 5 j , v = 6 i Find the angle between the vectors.

Answered: 1 week ago