-- Listado de pacientes con 4 o más ordenes de consulta sin cerrar
SELECT pacientePersonaId, count(*) as total FROM `centromedicobck`.`orden` where cierreid is null AND tipoBono = 0 group by pacientePersonaId having total>3;