คำนวณจำนวนยาที่ผู้ป่วย 52898 จ่ายในปี 2105 ไม่จำเป็นต้องใช้ตารางทั้งหมด
calculate the number of medications that patient 52898 has been prescribed in 2105.It is not neccessary to use all the tables.
 inputevents_cv:  row_id [ number]  subject_id [ number]  hadm_id [ number]  icustay_id [ number]  charttime [ time]  itemid [ number]  amount [ number] 
SELECT COUNT(*) FROM prescriptions WHERE prescriptions.hadm_id IN (SELECT admissions.hadm_id FROM admissions WHERE admissions.subject_id = 52898) AND STRFTIME('%y', prescriptions.startdate) = '2105'