ค่ารักษาพยาบาลสูงสุดสำหรับยาชื่อโลชั่นกรดแลคติค 12% คือเท่าไร?ไม่จำเป็นต้องใช้ทุกโต๊ะ
what is the maximum hospital cost for a drug with a name called lactic acid 12% lotion?It is not neccessary to use all the tables.
 cost:  row_id [ number]  subject_id [ number]  hadm_id [ number]  event_type [ text]  event_id [ number]  chargetime [ time]  cost [ number] 
SELECT MAX(t1.c1) FROM (SELECT SUM(cost.cost) AS c1 FROM cost WHERE cost.hadm_id IN (SELECT prescriptions.hadm_id FROM prescriptions WHERE prescriptions.drug = 'lactic acid 12% lotion') GROUP BY cost.hadm_id) AS t1