ในระหว่างการเยี่ยมโรงพยาบาลครั้งแรก ปริมาณเจนทามัยซิน irrigatin โดยเฉลี่ยต่อวันของผู้ป่วย 11688 คือเท่าใด? ไม่จำเป็นที่จะต้องใช้ตารางทั้งหมด
during the first hospital visit, what was the daily average dose of gentamycin irrigatin of patient 11688?It is not neccessary to use all the tables.
 transfers:  row_id [ number]  subject_id [ number]  hadm_id [ number]  icustay_id [ number]  eventtype [ text]  careunit [ text]  wardid [ number]  intime [ time]  outtime [ time] 
SELECT AVG(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 = 11688 AND NOT admissions.dischtime IS NULL ORDER BY admissions.admittime LIMIT 1)) AND inputevents_cv.itemid IN (SELECT d_items.itemid FROM d_items WHERE d_items.label = 'gentamycin irrigatin' AND d_items.linksto = 'inputevents_cv') GROUP BY STRFTIME('%y-%m-%d', inputevents_cv.charttime)