ยาสี่ชนิดที่ต้องสั่งจ่ายบ่อยที่สุดสำหรับผู้ป่วยที่ได้รับคลอธาลิโดนในเวลาเดียวกันจนถึงปี 2104 คืออะไร? ไม่จำเป็นต้องใช้ตารางทั้งหมด
what are the four most frequently prescribed medications for patients who were also prescribed with chlorthalidone at the same time until 2104?It is not neccessary to use all the tables.
 cost:  row_id [ number]  subject_id [ number]  hadm_id [ number]  event_type [ text]  event_id [ number]  chargetime [ time]  cost [ number] 
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 = 'chlorthalidone' AND STRFTIME('%y', prescriptions.startdate) <= '2104') 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) <= '2104') 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 <= 4