Question $5$ of $9$

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 emptoye$$s

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.