ยาใหม่ที่กำหนดให้กับผู้ป่วย 31854 ในวันนี้เทียบกับเมื่อวานคืออะไร?ไม่จำเป็นต้องใช้ตารางทั้งหมด
what are the new drugs prescribed to patient 31854 today compared to that yesterday?It is not neccessary to use all the tables.
 d_icd_procedures:  row_id [ number]  icd9_code [ text]  short_title [ text]  long_title [ text] 
SELECT prescriptions.drug FROM prescriptions WHERE prescriptions.hadm_id IN (SELECT admissions.hadm_id FROM admissions WHERE admissions.subject_id = 31854) AND DATETIME(prescriptions.startdate, 'start of day') = DATETIME(CURRENT_TIME(), 'start of day', '-0 day') EXCEPT SELECT prescriptions.drug FROM prescriptions WHERE prescriptions.hadm_id IN (SELECT admissions.hadm_id FROM admissions WHERE admissions.subject_id = 31854) AND DATETIME(prescriptions.startdate, 'start of day') = DATETIME(CURRENT_TIME(), 'start of day', '-1 day')