Q. What is the significance of the statement "GROUP BY d.name" in the following MySQL statement?
SELECT d.name, COUNT (emp_id) emp_no
FROM department d INNER JOIN Employee e
ON d.dept_id=e.emp_id
GROUP BY d.name
SELECT d.name, COUNT (emp_id) emp_no
FROM department d INNER JOIN Employee e
ON d.dept_id=e.emp_id
GROUP BY d.name
✅ Correct Answer: (B)
Aggregation of the field "name" of table "department"
Explanation: This SQL statement is designed to count the number of employees in each department. The key part you are asking about is "GROUP BY d.name".