Question: Question 1 1 . Create a query that will show the IT department s name and average salary ( rounded to the nearest hundred dollars

Question 11. Create a query that will show the IT departments name and average salary (rounded to the nearest hundred dollars) along with the 2 departments with average salaries closest to ITs 1 with average salaries above ITs and 1 with salaries below ITs. Order the results from highest to lowest average salaries.

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!

Q:

Drive (miles) 36 20 88 6 71 42 76 63 36 63 38 28 55 33 40 80 86 83 4 39 25 25 54 54 81 73 29 76 78 77 42 36 71 94 6 State MI IL CA IL MI IL NY PA TX NY OR NY OH SC IL NV FL FL NY SC CA GA FL CA CA FL...

Q:

Question 1 a. Create a query that displays the employees names and indicates the amounts of their salaries through asterisks. Each asterisk signifies hundred dollars. Sort the data in descending...

Q:

Drive (miles) 4 6 6 20 25 25 28 29 33 36 36 36 36 36 40 42 42 54 54 55 63 63 71 71 73 76 76 76 78 80 80 80 80 88 94 State MI SC OR MI GA CA NY TX SC TX CA MI TX OR IL FL IL FL NY OH PA OR MI MI FL NY...

Q:

The following are the queries that are to be written using the BaseBall database you created for the course. Each question is worth 5 points. Points will be taken off for incorrect formatting (dollar...

Q:

Consider the following schema tables and answer the questions below CREATE TABLE DEPT ( DEPTNO NUMBER(2) NOT NULL, DNAME CHAR(14), LOC CHAR(13), CONSTRAINT DEPT_PRIMARY_KEY PRIMARY KEY (DEPTNO));...

Q:

Find the name of instructor who works in the physics department and his salary is between 100000 and 90000 (1 Mark) 2. Find the name of students who study in the electrical engineering department and...

Q:

Consider the following schema tables and answer the questions below CREATE TABLE DEPT ( DEPTNO NUMBER(2) NOT NULL, DNAME CHAR(14), LOC CHAR(13), CONSTRAINT DEPT_PRIMARY_KEY PRIMARY KEY (DEPTNO));...

Q:

Final Exam MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question. Solve the problem. 1) The average age of the students in a statistics class is 22...

Q:

Final Exam MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question. Solve the problem. 1) The average age of the students in a statistics class is 22...

Q:

Final Exam MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question. Solve the problem. 1) The average age of the students in a statistics class is 22...

Q:

An object is placed 12 cm to the left of a lens of focal length 10 cm. A second lens of focal length 12.5 cm is placed 20 cm to the right of the first lens. (a) Find the position of the final image....

Q:

Do managers of international firms need to approach organizational design differently from their counterparts in domestic firms? Why or why not?

Q:

Safari Digital Ltd . , a growing e - commerce platform, has realized that it underreported its revenue for the last three years due to an accounting error. The company now has two options: Option A:...

Q:

OpenSeas, Inc. is evaluating the purchase of a new cruise ship. The ship will cost $496 million, and will operate for 20 years. OpenSeas expects annual cash flows from operating the ship to be $69.2...

Q:

III. What will be on the new SlickBoards Web site? A. Outline all the new information about the products that will be on the Web site and how it will increase sales B. Explain how clients will be...

Q:

II. Why do we need a new SlickBoards Web site? A. Overview of our current Web site and its deficiencies B. Present the concept of the new Web site, why we needed a revamp, and how it improves on the...

Q:

How do you feel about group meetings? Do you find them energizing, boring, a waste of time? Consider an effective meeting and an ineffective meeting that youve attended. To what degree did the...