ในปี 05/ปีนี้ มีการกำหนดแท็บ amiodarone 200 มก., famotidine (pf) หรือ metoprolol tartrate สำหรับผู้ป่วย 029-27704 หรือไม่ไม่จำเป็นต้องใช้ตารางทั้งหมด
in 05/this year amiodarone 200 mg tab, famotidine (pf) or metoprolol tartrate were prescribed for patient 029-27704?It is not neccessary to use all the tables.
 diagnosis:  diagnosisid [ number]  patientunitstayid [ number]  diagnosisname [ text]  diagnosistime [ time]  icd9code [ text] 
SELECT COUNT(*) > 0 FROM medication WHERE medication.patientunitstayid IN (SELECT patient.patientunitstayid FROM patient WHERE patient.patienthealthsystemstayid IN (SELECT patient.patienthealthsystemstayid FROM patient WHERE patient.uniquepid = '029-27704')) AND medication.drugname IN ('amiodarone 200 mg tab', 'famotidine (pf)', 'metoprolol tartrate') AND DATETIME(medication.drugstarttime, 'start of year') = DATETIME(CURRENT_TIME(), 'start of year', '-0 year') AND STRFTIME('%m', medication.drugstarttime) = '05'