What is the significance of the statement “GROUP BY d.name” in the following MySQL statement?

Sorting of the field “name”

Aggregation of the field “name” of both table

Aggregation of the field “name” of table “department”

What is the significance of the statement “GROUP BY d.name” in the

1.	What is the significance of the statement “GROUP BY d.name” in the following MySQL statement?
A.	Aggregation of the field “name” of both table
B.	Aggregation of the field “name” of table “department”
C.	Sorting of the field “name”
D.	None of the mentioned
Answer» C. Sorting of the field “name”