instruction: count the numbers of patients who have been diagnosed with acute respiratory failure - due to obstructive lung disease.
response: SELECT COUNT(DISTINCT patient.uniquepid) FROM patient WHERE patient.patientunitstayid IN (SELECT diagnosis.patientunitstayid FROM diagnosis WHERE diagnosis.diagnosisname = 'acute respiratory failure - due to obstructive lung disease')