count the patients who were diagnosed with ulcer of heel & midfoot since 5 years ago.
select count( distinct admissions.subject_id ) from admissions where admissions.hadm_id in ( select diagnoses_icd.hadm_id from diagnoses_icd where diagnoses_icd.icd9_code = ( select d_icd_diagnoses.icd9_code from d_icd_diagnoses where d_icd_diagnoses.short_title = 'ulcer of heel & midfoot' ) and datetime(diagnoses_icd.charttime) >= datetime(current_time,'-5 year') )