instruction: provide the number of patients whose admission type is emergency and days of hospital stay is greater than 23?
response: SELECT COUNT(DISTINCT demographic.subject_id) FROM demographic WHERE demographic.admission_type = "EMERGENCY" AND demographic.days_stay > "23"