when patient 31696 has left the hospital the last time in a year before?
select admissions.dischtime from admissions where admissions.subject_id = 31696 and datetime(admissions.dischtime,'start of year') = datetime(current_time,'start of year','-1 year') order by admissions.dischtime desc limit 1