จำนวนโฟลีย์สูงสุดต่อวันที่ให้แก่ผู้ป่วย 72198 ในการเยี่ยมห้องผู้ป่วยหนักครั้งแรกคือเท่าใด? ไม่จำเป็นต้องใช้ตารางทั้งหมด
what was the daily maximum amount of foley given to patient 72198 on the first intensive care unit visit?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 MAX(outputevents.value) FROM outputevents WHERE outputevents.icustay_id IN (SELECT icustays.icustay_id FROM icustays WHERE icustays.hadm_id IN (SELECT admissions.hadm_id FROM admissions WHERE admissions.subject_id = 72198) AND NOT icustays.outtime IS NULL ORDER BY icustays.intime LIMIT 1) AND outputevents.itemid IN (SELECT d_items.itemid FROM d_items WHERE d_items.label = 'foley' AND d_items.linksto = 'outputevents') GROUP BY STRFTIME('%y-%m-%d', outputevents.charttime)