count the number of people who were diagnosed with chr kidney dis stage iii until 4 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 = 'chr kidney dis stage iii' ) and datetime(diagnoses_icd.charttime) <= datetime(current_time,'-4 year') )