จำนวนผู้ป่วยที่ได้รับการส่องกล้องหลอดลม-ด้วยการแปรงฟันในปีนี้ ไม่จำเป็นต้องใช้ทุกโต๊ะ
the number of patients who have received a bronchoscopy - with brushings in this year.It is not neccessary to use all the tables.
 medication:  medicationid [ number]  patientunitstayid [ number]  drugname [ text]  dosage [ text]  routeadmin [ text]  drugstarttime [ time]  drugstoptime [ time] 
SELECT COUNT(DISTINCT patient.uniquepid) FROM patient WHERE patient.patientunitstayid IN (SELECT treatment.patientunitstayid FROM treatment WHERE treatment.treatmentname = 'bronchoscopy - with brushings' AND DATETIME(treatment.treatmenttime, 'start of year') = DATETIME(CURRENT_TIME(), 'start of year', '-0 year'))