ระบุปริมาณขั้นต่ำต่อปีของ tpn d11.0 ที่ผู้ป่วย 4684 ได้รับจนถึง 06/14/2104 ไม่จำเป็นต้องใช้ตารางทั้งหมด
indicate the yearly minimum dose of tpn d11.0 that patient 4684 has received until 06/14/2104.It is not neccessary to use all the tables.
 procedures_icd:  row_id [ number]  subject_id [ number]  hadm_id [ number]  icd9_code [ text]  charttime [ time] 
SELECT MIN(inputevents_cv.amount) FROM inputevents_cv WHERE inputevents_cv.icustay_id IN (SELECT icustays.icustay_id FROM icustays WHERE icustays.hadm_id IN (SELECT admissions.hadm_id FROM admissions WHERE admissions.subject_id = 4684)) AND inputevents_cv.itemid IN (SELECT d_items.itemid FROM d_items WHERE d_items.label = 'tpn d11.0' AND d_items.linksto = 'inputevents_cv') AND STRFTIME('%y-%m-%d', inputevents_cv.charttime) <= '2104-06-14' GROUP BY STRFTIME('%y', inputevents_cv.charttime)