-- ---------------------------------------------------------------
-- statistiques traitement programme régul
-- ---------------------------------------------------------------
select type, statut, count(*)
from operation_regul
group by type, statut;

-- ---------------------------------------------------------------
-- Motif non ecriture pendant regul carte
-- ---------------------------------------------------------------
select remarque, count(*)
from operation_regul
where statut='RJ'
and type='C'
group by remarque;

-- ---------------------------------------------------------------
-- Motif non ecriture pendant regul ticket
-- ---------------------------------------------------------------
select remarque, count(*)
from operation_regul
where statut='RJ'
and type='T'
group by remarque;