CREATE VIEW abs_view AS

	SELECT 

		id_personnel, SUM(nb_heures) AS total 

	FROM 

		absences 

	WHERE 

		jour >= '2021-02-01'

		AND

		jour <= '2021-02-28'

    GROUP BY

    	id_personnel