mcv ของผู้ป่วย 94757 จากค่าที่วัดครั้งสุดท้ายในการมาโรงพยาบาลครั้งแรกมากกว่าที่วัดครั้งแรกในการมาโรงพยาบาลครั้งแรกหรือไม่ ไม่จำเป็นต้องใช้ตารางทั้งหมด
is the mcv of patient 94757 from the value last measured on the first hospital visit greater than first measured on the first hospital visit?It is not neccessary to use all the tables.
 patients:  row_id [ number]  subject_id [ number]  gender [ text]  dob [ time]  dod [ time] 
SELECT (SELECT labevents.valuenum FROM labevents WHERE labevents.hadm_id IN (SELECT admissions.hadm_id FROM admissions WHERE admissions.subject_id = 94757 AND NOT admissions.dischtime IS NULL ORDER BY admissions.admittime LIMIT 1) AND labevents.itemid IN (SELECT d_labitems.itemid FROM d_labitems WHERE d_labitems.label = 'mcv') ORDER BY labevents.charttime DESC LIMIT 1) > (SELECT labevents.valuenum FROM labevents WHERE labevents.hadm_id IN (SELECT admissions.hadm_id FROM admissions WHERE admissions.subject_id = 94757 AND NOT admissions.dischtime IS NULL ORDER BY admissions.admittime LIMIT 1) AND labevents.itemid IN (SELECT d_labitems.itemid FROM d_labitems WHERE d_labitems.label = 'mcv') ORDER BY labevents.charttime LIMIT 1)