find the number of patients who have been admitted in hospital since 1 year ago.
select count( distinct admissions.subject_id ) from admissions where datetime(admissions.admittime) >= datetime(current_time,'-1 year')