ในเดือนนี้มียากี่ตัวที่จ่ายให้กับผู้ป่วย 5828?ไม่จำเป็นต้องใช้ตารางทั้งหมด
how many drugs were prescribed to patient 5828 in this month?It is not neccessary to use all the tables.
 microbiologyevents:  row_id [ number]  subject_id [ number]  hadm_id [ number]  charttime [ time]  spec_type_desc [ text]  org_name [ text] 
SELECT COUNT(*) FROM prescriptions WHERE prescriptions.hadm_id IN (SELECT admissions.hadm_id FROM admissions WHERE admissions.subject_id = 5828) AND DATETIME(prescriptions.startdate, 'start of month') = DATETIME(CURRENT_TIME(), 'start of month', '-0 month')