ระบุจำนวนผู้ป่วยที่รักษาตัวในโรงพยาบาลมากกว่า 11 วัน และชื่อยาคือ คลอโรไทอาไซด์ ไม่จำเป็นต้องใช้ตารางทั้งหมด
provide the number of patients whose days of hospital stay is greater than 11 and drug name is chlorothiazide?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 prescriptions ON demographic.hadm_id = prescriptions.hadm_id WHERE demographic.days_stay > "11" AND prescriptions.drug = "Chlorothiazide"