CALL sp_getnombrestatutpoliceperiode('2022-05-18','2022-06-15',233)


SELECT * FROM police WHERE libellePolice LIKE '%COM%'


SELECT COUNT(0) INTO @nb_beneficiaire_police 
	FROM beneficiaire 
	WHERE dateEntree BETWEEN '2022-05-18' AND '2022-06-15'
	AND (idPolice=233)
	AND (enVigueur="1")
	AND sorti ="0";
	
	
	SELECT @nb_beneficiaire_police 
	
	
SELECT fn_nb_beneficiaire_police2_periode('2022-05-18','2022-06-15',233) AS nbpolice