make a count of the number of patients who are discharged from the hospital until 1 year ago.
select count( distinct admissions.subject_id ) from admissions where admissions.dischtime is not null and datetime(admissions.dischtime) <= datetime(current_time,'-1 year')