ชื่อยาอะไร ผู้ป่วย 009-5351 แพ้ยาเมื่อ 06/2105 ไม่จำเป็นต้องใช้ทุกโต๊ะ
what was the name of the drug patient 009-5351 was allergic to it in 06/2105.It is not neccessary to use all the tables.
 lab:  labid [ number]  patientunitstayid [ number]  labname [ text]  labresult [ number]  labresulttime [ time] 
SELECT allergy.drugname FROM allergy WHERE allergy.patientunitstayid IN (SELECT patient.patientunitstayid FROM patient WHERE patient.patienthealthsystemstayid IN (SELECT patient.patienthealthsystemstayid FROM patient WHERE patient.uniquepid = '009-5351')) AND STRFTIME('%y-%m', allergy.allergytime) = '2105-06'