Question: 4 . 1 . 1 0 : Aggregate functions and NULL values. Refer to the Compensation table below. Compensation ID Name Salary Bonus 2 5

4.1.10: Aggregate functions and NULL values.
Refer to the Compensation table below.
Compensation
ID Name Salary Bonus
2538 Lisa Ellison 115000 NULL
5348 Sam Snead 3500055000
6381 Maria Rodriguez 950003000
8820 Jiho Chen NULL 48000
What is the result of the following statements?
1)
SELECT MAX(Bonus)
FROM Compensation;

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 Accounting Questions!