select matrix_odontograma.cedula as cedula, primer_nombre as nombre, primer_apellido as apellido, genero as genero,
fecha_nacimiento as fechanacimiento
from matrix_odontograma, pacientes
where (matrix_odontograma.cedula = pacientes.cedula) and (iddientes = 1 and superficie = 1 and
nombre_enfermedad = 'caries' or iddientes = 2 and superficie = 6 and nombre_enfermedad = 'ppr' or iddientes = 3 and superficie = 6 and nombre_enfermedad = 'extraido' )
and matrix_odontograma.cedula in (select cedula, count(cedula) as cont
from matrix_odontograma
group by cedula having cont = 3)
group by cedula
having count(matrix_odontograma.cedula) between 3 and 3