การเข้าพักครั้งแรกของผู้ป่วย 73423 อยู่ในห้องผู้ป่วยหนักนานแค่ไหน?ไม่จำเป็นต้องใช้โต๊ะทั้งหมด
how long patient 73423's first stay was in the intensive care unit?It is not neccessary to use all the tables.
 microbiologyevents:  row_id [ number]  subject_id [ number]  hadm_id [ number]  charttime [ time]  spec_type_desc [ text]  org_name [ text] 
SELECT STRFTIME('%j', icustays.outtime) - STRFTIME('%j', icustays.intime) FROM icustays WHERE icustays.hadm_id IN (SELECT admissions.hadm_id FROM admissions WHERE admissions.subject_id = 73423) AND NOT icustays.outtime IS NULL ORDER BY icustays.intime LIMIT 1