Solved programming problem

Show the location_id and corresponding no of departments in that location from departments table

Source code

SELECT LOCATION_ID, COUNT(DEPARTMENT_ID)

FROM departments

GROUP BY LOCATION_ID;
Join the discussion

Add your comment