instruction: what number of patients were admitted in emergency room for procedure titled opn lft hemicolectomy nec?
response: SELECT COUNT(DISTINCT demographic.subject_id) FROM demographic INNER JOIN procedures ON demographic.hadm_id = procedures.hadm_id WHERE demographic.admission_location = "EMERGENCY ROOM ADMIT" AND procedures.short_title = "Opn lft hemicolectmy NEC"