A company tracks which employees are in its various departments using the following two tables:

TABLE departments

id INTEGER PRIMARY KEY NOT NULL

name VARCHAR$(50)$ NOT NULL

TABLE employees

id INTEGER PRIMARY KEY NOT NULL

departmentId INTEGER NOT NULL

name VARCHAR$(50)$ NOT NULL

FOREIGN KEY $($departmentId$)$ REFERENCES departments$($id$)$

Populate the empty table departmentReports, defined below, with the total number of employees in each department.

TABLE departmentReports

departmentName VARCHAR$(50)$ NOT NULL

employeeCount INTEGER NOT NULL

See the example case for more details.

conside r some department doesndoesn't have emolployees and some departmens have same name