ขอทราบจำนวนคนไข้ที่มีสถานภาพสมรสเป็นโสด และรหัสขั้นตอน icd9 คือ 8960 ค่ะ ไม่จำเป็นต้องใช้ตารางทั้งหมดค่ะ
give me the number of patients whose marital status is single and procedure icd9 code is 8960?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.marital_status = "SINGLE" AND procedures.icd9_code = "8960"