ผู้ป่วย 028-47306 ไปโรงพยาบาลครั้งสุดท้ายในปีนี้ได้อย่างไร?ไม่จำเป็นต้องใช้โต๊ะทั้งหมด
how did patient 028-47306 last visit in this year to the hospital?It is not neccessary to use all the tables.
 allergy:  allergyid [ number]  patientunitstayid [ number]  drugname [ text]  allergyname [ text]  allergytime [ time] 
SELECT patient.hospitaladmitsource FROM patient WHERE patient.uniquepid = '028-47306' AND DATETIME(patient.hospitaladmittime, 'start of year') = DATETIME(CURRENT_TIME(), 'start of year', '-0 year') ORDER BY patient.hospitaladmittime DESC LIMIT 1