GROUP BY d.name
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 these
Answer:A
GROUP BY d.name
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 these
Explanation: “GROUP BY” clause s used for aggregation of field.