takes ID course_id sec_id semester year grade student ID name dept_name tot_cred course course id title section course id sec_id semester year building room_no time_slot_id department dept_name building budget advisor s id i id dept_name credits time_slot time slot id day start_time end_time prereq classroom building room_no capacity course_id prereq_id instructor ID name dept_name salary teaches ID course id sec_id semester year Consider a query to find the number of instructors in each department. a) Give your answer using aggregate function. b) One possible answer is as follow. Is it correct? Give your reason. SELECT dept_name, count (DICTINCT name) FROM instructor GROUP BY dept_name