จำนวนผู้ป่วยที่เข้ารับการรักษาในโรงพยาบาลแบบเร่งด่วนที่ถูกปิดชิ้นเนื้อหลอดลมเป็นจำนวนเท่าใด?ไม่จำเป็นต้องใช้ตารางทั้งหมด
what is the number of urgent hospital admission patients who had closed biopsy of bronchus?It is not neccessary to use all the tables.
 demographic:  subject_id [ text]  hadm_id [ text]  name [ text]  marital_status [ text]  age [ text]  dob [ text]  gender [ text]  language [ text]  religion [ text]  admission_type [ text]  days_stay [ text]  insurance [ text]  ethnicity [ text]  expire_flag [ text]  admission_location [ text]  discharge_location [ text]  diagnosis [ text]  dod [ text]  dob_year [ text]  dod_year [ text]  admittime [ text]  dischtime [ text]  admityear [ text] 
SELECT COUNT(DISTINCT demographic.subject_id) FROM demographic INNER JOIN procedures ON demographic.hadm_id = procedures.hadm_id WHERE demographic.admission_type = "URGENT" AND procedures.short_title = "Closed bronchial biopsy"