จำนวนผู้ป่วยที่เข้ารับการรักษาแบบเร่งด่วนและวินิจฉัยชื่อสั้นว่า enthesopathy of hip คือเท่าไร?ไม่จำเป็นต้องใช้ตารางทั้งหมด
what is the number of patients whose admission type is urgent and diagnoses short title is enthesopathy of hip?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 diagnoses ON demographic.hadm_id = diagnoses.hadm_id WHERE demographic.admission_type = "URGENT" AND diagnoses.short_title = "Enthesopathy of hip"