instruction: count the number of patients whose ethnicity is asian and primary disease is mesenteric ischemia?
response: SELECT COUNT(DISTINCT demographic.subject_id) FROM demographic WHERE demographic.ethnicity = "ASIAN" AND demographic.diagnosis = "MESENTERIC ISCHEMIA"