SELECT patient.id
  FROM patient, diagnosis
 WHERE diagnosis.patient = patient.id
   AND diagnosis.code BETWEEN (296.1 AND 314.0)
   AND NOT EXISTS (
        SELECT patient
          FROM diagnosis d_int
         WHERE d_int.patient = patient.id
           AND d_int.code = 305.1
       )