ใบสั่งยาใหม่บนใบสั่งยาของผู้ป่วย 68280 วันนี้เป็นอย่างไร เทียบกับใบสั่งยาเมื่อวาน? ไม่จำเป็นต้องใช้ตารางทั้งหมด
what were the new prescriptions on the prescription of patient 68280 today compared to the prescription yesterday?It is not neccessary to use all the tables.
 patients:  row_id [ number]  subject_id [ number]  gender [ text]  dob [ time]  dod [ time] 
SELECT prescriptions.drug FROM prescriptions WHERE prescriptions.hadm_id IN (SELECT admissions.hadm_id FROM admissions WHERE admissions.subject_id = 68280) 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 = 68280) AND DATETIME(prescriptions.startdate, 'start of day') = DATETIME(CURRENT_TIME(), 'start of day', '-1 day')