ค่า ph สูงสุดรายวันของผู้ป่วย 64292 จนถึง 4 เดือนที่แล้วคือเท่าใด?ไม่จำเป็นต้องใช้ตารางทั้งหมด
what is the daily maximum ph value for patient 64292 until 4 months ago?It is not neccessary to use all the tables.
 admissions:  row_id [ number]  subject_id [ number]  hadm_id [ number]  admittime [ time]  dischtime [ time]  admission_type [ text]  admission_location [ text]  discharge_location [ text]  insurance [ text]  language [ text]  marital_status [ text]  ethnicity [ text]  age [ number] 
SELECT MAX(labevents.valuenum) FROM labevents WHERE labevents.hadm_id IN (SELECT admissions.hadm_id FROM admissions WHERE admissions.subject_id = 64292) AND labevents.itemid IN (SELECT d_labitems.itemid FROM d_labitems WHERE d_labitems.label = 'ph') AND DATETIME(labevents.charttime) <= DATETIME(CURRENT_TIME(), '-4 month') GROUP BY STRFTIME('%y-%m-%d', labevents.charttime)