Question: Based on the above Staff table, what happens when we run the following SQL query? select fName, max ( salary ) from Staff where sex

Based on the above Staff table, what happens when we run the following SQL query?
select fName, max (salary) from Staff where sex='F';
a. The output will show the staff ('Susan',30000) who has maximum salary.
b. The output will show the staff ('John',30000) who has maximum salary
c. There is an error and no output will be produced
d. The output staff name is not necessary to have the maximum salary
please select the correct multiple choice answer.
 Based on the above Staff table, what happens when we run

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!