CODE EXAMPLE FOR SQL

How to write triggers to increment or decrement the number of employees

CREATE TRIGGER NEW_HIRED
     AFTER INSERT ON EMPLOYEE
     FOR EACH ROW
     UPDATE COMPANY_STATS SET NBEMP = NBEMP + 1