Question: Q 4 . Aggregate functions can be applied to a particular column ( attribute ) , that is , a collection of values. ( a
Q Aggregate functions can be applied to a particular column attribute that is a collection of values.
a Explain how the NULL values are handled when the SUM function is applied to the attribute Hours in the WORKSON table. If the collection becomes empty because all values are NULL, what will the SUM function return?
b If the collection becomes empty because all values are NULL, what will the COUNT function return?
c Explain how will the COUNT handle the tuple of the query result that contain NULL values of some attributes in the tuple?
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
