โรคภูมิแพ้ที่คนไข้ 030-40287 เป็นชื่ออะไร ไม่จำเป็นต้องใช้ทุกโต๊ะ
what was the name of that allergy that patient 030-40287 had.It is not neccessary to use all the tables.
 microlab:  microlabid [ number]  patientunitstayid [ number]  culturesite [ text]  organism [ text]  culturetakentime [ time] 
SELECT allergy.allergyname FROM allergy WHERE allergy.patientunitstayid IN (SELECT patient.patientunitstayid FROM patient WHERE patient.patienthealthsystemstayid IN (SELECT patient.patienthealthsystemstayid FROM patient WHERE patient.uniquepid = '030-40287'))