ตั้งแต่ปี 2104 การทดสอบในห้องปฏิบัติการสี่อันดับแรกที่ให้ผู้ป่วยบ่อยที่สุดในเดือนเดียวกันหลังจากพวกเขาได้รับการวินิจฉัยว่าเป็นโรคหลอดเลือดแดงแข็งโดยไม่จำเป็นคืออะไร? ไม่จำเป็นที่จะต้องใช้ตารางทั้งหมด
since 2104, what are the top four most frequently given lab tests to patients in the same month after they were diagnosed with atherosclerosis nec?It is not neccessary to use all the tables.
 admissions:  row_id [ number]  subject_id [ number]  hadm_id [ number]  admittime [ time]  dischtime [ time]  admission_type [ text]  admission_location [ text]  discharge_location [ text]  insurance [ text]  language [ text]  marital_status [ text]  ethnicity [ text]  age [ number] 
SELECT d_labitems.label FROM d_labitems WHERE d_labitems.itemid IN (SELECT t3.itemid FROM (SELECT t2.itemid, 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 = 'atherosclerosis nec') AND STRFTIME('%y', diagnoses_icd.charttime) >= '2104') AS t1 JOIN (SELECT admissions.subject_id, labevents.itemid, labevents.charttime FROM labevents JOIN admissions ON labevents.hadm_id = admissions.hadm_id WHERE STRFTIME('%y', labevents.charttime) >= '2104') 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.itemid) AS t3 WHERE t3.c1 <= 4)