I don't understand why my solution is not working.

I am trying to count the number of employees by department in a database.

There are two tables:

```
CREATE TABLE DEPARTMENT
(
    NAME VARCHAR(32) NOT NULL,
    ID INT NOT NULL PRIMARY KEY
);

CREATE TABLE EMPLOYEE
(
    NAME VARCHAR(32) PRIMARY KEY NOT NULL,
    DEPARTMENT INT NOT NULL REFERENCES DEPARTMENT(ID)
);

```

and I have created a view to show the number of employees in departments.

```
CREATE 
OR REPLACE VIEW VIEW_NB AS 
SELECT
   DEPARTMENT.NAME AS DEPARTEMENT,
   count(*) AS nb 
FROM
   DEPARTMENT 
   LEFT JOIN
      EMPLOYEE 
      ON DEPARTMENT.ID = EMPLOYEE.DEPARTMENT 
GROUP BY
   DEPARTMENT.ID,
   DEPARTMENT.NAME;
SELECT
   ADD_DEPARTMENT('FRANCE', 10);
SELECT
   ADD_DEPARTMENT('SPAIN', 100);
SELECT
   ADD_EMPLOYEE('JOSE', 10);

```

result is 

```
 departement | nb 
-------------+----
 FRANCE      |  1
 SPAIN       |  1

```

but it should be

```
 departement | nb 
-------------+----
 FRANCE      |  0
 SPAIN       |  1

```

I understand the need to use left joins.
However my view has at least 1 employee for every department, even when they don't have employee.

Did I miss something? If yes what?