ปีที่แล้วผู้ป่วย 030-72509 เคยมาโรงพยาบาลกี่ครั้ง?ไม่จำเป็นต้องใช้โต๊ะทั้งหมด
how many times has patient 030-72509 ever visited the hospital the last year?It is not neccessary to use all the tables.
 treatment:  treatmentid [ number]  patientunitstayid [ number]  treatmentname [ text]  treatmenttime [ time] 
SELECT COUNT(DISTINCT patient.patienthealthsystemstayid) FROM patient WHERE patient.uniquepid = '030-72509' AND DATETIME(patient.hospitaladmittime, 'start of year') = DATETIME(CURRENT_TIME(), 'start of year', '-1 year')