GROUPING #4 Which of the following queries would return the number of different department specialties that have been documented for departments? SELECT ONE OF THE FOLLOWING (3 PTS) A. SELECT COUNT( Department Specialty) FROM Departmentdim B. SELECT DISTINCT COUNT(Department Specialty ) FROM Department Dim C. SELECT COUNT( DISTINCT Department Specialty ) FROM Departmentim D. SELECT COUNT(*) FROM Department Dim GROUP BY Department Specialty