ตั้งแต่วันที่ 26/04/2105 ค่า bp ของหลอดเลือดแดงแรก [ซิสโตลิก] สำหรับผู้ป่วย 31854 คืออะไร? ไม่จำเป็นต้องใช้ตารางทั้งหมด
since 04/26/2105, what was first arterial bp [systolic] for patient 31854?It is not neccessary to use all the tables.
 d_icd_diagnoses:  row_id [ number]  icd9_code [ text]  short_title [ text]  long_title [ text] 
SELECT 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 = 31854)) AND chartevents.itemid IN (SELECT d_items.itemid FROM d_items WHERE d_items.label = 'arterial bp [systolic]' AND d_items.linksto = 'chartevents') AND STRFTIME('%y-%m-%d', chartevents.charttime) >= '2105-04-26' ORDER BY chartevents.charttime LIMIT 1