Bonjour,
Un truc du genre:


select idhotesse,sum(case when type_operation = 'remboursement' then 1 else 0 end),count(*)
from transaction
inner join operation on operation.id =...