ยาที่กำหนดบ่อยที่สุดสามชนิดสำหรับผู้ป่วยที่ได้รับแอมโลดิพีนเบซิเลตในเวลาเดียวกันในปี 2105 คืออะไร? ไม่จำเป็นต้องใช้ตารางทั้งหมด
what are the three most frequently prescribed drugs for patients who are also prescribed amlodipine besylate at the same time in 2105?It is not neccessary to use all the tables.
 d_items:  row_id [ number]  itemid [ number]  label [ text]  linksto [ text] 
SELECT t3.drug FROM (SELECT t2.drug, DENSE_RANK() OVER (ORDER BY COUNT(*) DESC) AS c1 FROM (SELECT admissions.subject_id, prescriptions.startdate FROM prescriptions JOIN admissions ON prescriptions.hadm_id = admissions.hadm_id WHERE prescriptions.drug = 'amlodipine besylate' AND STRFTIME('%y', prescriptions.startdate) = '2105') AS t1 JOIN (SELECT admissions.subject_id, prescriptions.drug, prescriptions.startdate FROM prescriptions JOIN admissions ON prescriptions.hadm_id = admissions.hadm_id WHERE STRFTIME('%y', prescriptions.startdate) = '2105') AS t2 ON t1.subject_id = t2.subject_id WHERE DATETIME(t1.startdate) = DATETIME(t2.startdate) GROUP BY t2.drug) AS t3 WHERE t3.c1 <= 3