SQL query to find number of people department wise

• Use GROUP BY clause with department column

• Use COUNT function to count number of people

• Join tables if necessary