ชื่อของเอาต์พุตที่ผู้ป่วย 27172 มีครั้งแรกในวันที่ 09/12/ปีนี้คืออะไร? ไม่จำเป็นต้องใช้ตารางทั้งหมด
what were the names of the output that patient 27172 had first on 09/12/this year?It is not neccessary to use all the tables.
 inputevents_cv:  row_id [ number]  subject_id [ number]  hadm_id [ number]  icustay_id [ number]  charttime [ time]  itemid [ number]  amount [ number] 
SELECT d_items.label FROM d_items WHERE d_items.itemid IN (SELECT outputevents.itemid 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 = 27172)) AND DATETIME(outputevents.charttime, 'start of year') = DATETIME(CURRENT_TIME(), 'start of year', '-0 year') AND STRFTIME('%m-%d', outputevents.charttime) = '09-12' ORDER BY outputevents.charttime LIMIT 1)