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