Which of the following are the correct ways to use group functions?

You work as a Database Administrator for Domain.com. The company uses MySQL as its
database.
You want to use group functions, so you have decided to put an alias of group functions as ‘GP’.
Which of the following are the correct ways to use group functions?
Each correct answer represents a complete solution. Choose all that apply.

You work as a Database Administrator for Domain.com. The company uses MySQL as its
database.
You want to use group functions, so you have decided to put an alias of group functions as ‘GP’.
Which of the following are the correct ways to use group functions?
Each correct answer represents a complete solution. Choose all that apply.

A.
GP1(group_item) = result

B.
GP1(GP2(GP3(group_item))) = result

C.
GP1(GP2(group_item)) = result

D.
GP1(GP2(GPn(group_item))) = result



Leave a Reply 0

Your email address will not be published. Required fields are marked *