มีกี่ขั้นตอนของ thorac Drain pleurl cav ที่เสร็จสิ้น?ไม่จำเป็นต้องใช้ตารางทั้งหมด
how many thorac drain pleurl cav procedures were completed?It is not neccessary to use all the tables.
 d_icd_procedures:  row_id [ number]  icd9_code [ text]  short_title [ text]  long_title [ text] 
SELECT COUNT(*) FROM procedures_icd WHERE procedures_icd.icd9_code = (SELECT d_icd_procedures.icd9_code FROM d_icd_procedures WHERE d_icd_procedures.short_title = 'thorac drain pleurl cav')