i was wondering what patient 10211's average value of heart rate on 04/01/2104 was?
select avg(chartevents.valuenum) from chartevents where chartevents.icustay_id in ( select icustays.icustay_id from icustays where icustays.hadm_id in ( select admissions.hadm_id from admissions where admissions.subject_id = 10211 ) ) and chartevents.itemid in ( select d_items.itemid from d_items where d_items.label = 'heart rate' and d_items.linksto = 'chartevents' ) and strftime('%y-%m-%d',chartevents.charttime) = '2104-04-01'