For this Question: Determine the number of employees in each department.
Output the department name together with the corresponding number of employees.DataFrame/SQL Table with the following schema -
<schema>[{'name': 'worker', 'columns': [{'name': 'worker_id', 'type': 'int64'}, {'name': 'first_name', 'type': 'object'}, {'name': 'last_name', 'type': 'object'}, {'name': 'salary', 'type': 'int64'}, {'name': 'joining_date', 'type': 'datetime64[ns]'}, {'name': 'department', 'type': 'object'}]}]</schema>Each row in the new line and each value of a row separated by a |, i.e.,
0|1|2
1|2|3
2|3|4-, I have written this Solution Code: SELECT 
    department, 
    count(DISTINCT worker_id) AS num_of_workers
FROM worker
GROUP BY 
    department, In this Programming Language: SQL, Now tell me if this Code is compilable or not?