ในบรรดาผู้ป่วยที่ได้รับยา lidocaine แบบบัฟเฟอร์ 1% ยาชนิดใดที่ต้องสั่งจ่ายบ่อยที่สุด 4 ชนิดในเวลาเดียวกันของปีนี้? ไม่จำเป็นที่จะต้องใช้ทุกตาราง
among patients who have been prescribed buffered lidocaine 1%, what are the four most commonly prescribed drugs at the same time during this year?It is not neccessary to use all the tables.
 intakeoutput:  intakeoutputid [ number]  patientunitstayid [ number]  cellpath [ text]  celllabel [ text]  cellvaluenumeric [ number]  intakeoutputtime [ time] 
SELECT t3.drugname FROM (SELECT t2.drugname, DENSE_RANK() OVER (ORDER BY COUNT(*) DESC) AS c1 FROM (SELECT patient.uniquepid, medication.drugstarttime FROM medication JOIN patient ON medication.patientunitstayid = patient.patientunitstayid WHERE medication.drugname = 'buffered lidocaine 1%' AND DATETIME(medication.drugstarttime, 'start of year') = DATETIME(CURRENT_TIME(), 'start of year', '-0 year')) AS t1 JOIN (SELECT patient.uniquepid, medication.drugname, medication.drugstarttime FROM medication JOIN patient ON medication.patientunitstayid = patient.patientunitstayid WHERE DATETIME(medication.drugstarttime, 'start of year') = DATETIME(CURRENT_TIME(), 'start of year', '-0 year')) AS t2 ON t1.uniquepid = t2.uniquepid WHERE DATETIME(t1.drugstarttime) = DATETIME(t2.drugstarttime) GROUP BY t2.drugname) AS t3 WHERE t3.c1 <= 4