Question: Query 5 : Calculate the difference between the maximum possible salary ( for the position ) and the current actual salary for each employee who

Query 5: Calculate the difference between the maximum possible salary (for the position) and the current actual salary for each employee who is a Sales Manager and save the answer in a new column called Difference. Show City, MaxSal, Salary, and Difference (sort descending).[Create this query and save it as "Query 5"]
Which cities show salary differences less than $10,000? Select all that apply.
Minneapolis
Miami
Phoenix
Boston
Dallas
Denver
Chicago

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!