อะไรคือขั้นตอนที่ได้รับคำสั่งมากที่สุดสามขั้นตอนสำหรับผู้ป่วยที่เคยได้รับการวินิจฉัยว่าเป็นโรคลิ้นหัวใจไมทรัล ซึ่งเกิดขึ้นภายในเดือนเดียวกันของปีที่แล้ว? ไม่จำเป็นต้องใช้ตารางทั้งหมด
what are the three most commonly ordered procedures for patients who have previously been diagnosed with mitral valve disorder, which occurred within the same month last year?It is not neccessary to use all the tables.
 d_labitems:  row_id [ number]  itemid [ number]  label [ text] 
SELECT d_icd_procedures.short_title FROM d_icd_procedures WHERE d_icd_procedures.icd9_code IN (SELECT t3.icd9_code FROM (SELECT t2.icd9_code, DENSE_RANK() OVER (ORDER BY COUNT(*) DESC) AS c1 FROM (SELECT admissions.subject_id, diagnoses_icd.charttime FROM diagnoses_icd JOIN admissions ON diagnoses_icd.hadm_id = admissions.hadm_id WHERE diagnoses_icd.icd9_code = (SELECT d_icd_diagnoses.icd9_code FROM d_icd_diagnoses WHERE d_icd_diagnoses.short_title = 'mitral valve disorder') AND DATETIME(diagnoses_icd.charttime, 'start of year') = DATETIME(CURRENT_TIME(), 'start of year', '-1 year')) AS t1 JOIN (SELECT admissions.subject_id, procedures_icd.icd9_code, procedures_icd.charttime FROM procedures_icd JOIN admissions ON procedures_icd.hadm_id = admissions.hadm_id WHERE DATETIME(procedures_icd.charttime, 'start of year') = DATETIME(CURRENT_TIME(), 'start of year', '-1 year')) AS t2 ON t1.subject_id = t2.subject_id WHERE t1.charttime < t2.charttime AND DATETIME(t1.charttime, 'start of month') = DATETIME(t2.charttime, 'start of month') GROUP BY t2.icd9_code) AS t3 WHERE t3.c1 <= 3)