อะไรคือความแตกต่างของอัตราการเต้นของหัวใจของผู้ป่วย 4092 ที่วัดที่ 2104-07-02 110000 เทียบกับค่าที่วัดที่ 2104-07-02 050000?ไม่จำเป็นต้องใช้ตารางทั้งหมด
what are patient 4092's differences in heart rate measured at 2104-07-02 110000 compared to the value measured at 2104-07-02 050000?It is not neccessary to use all the tables.
 transfers:  row_id [ number]  subject_id [ number]  hadm_id [ number]  icustay_id [ number]  eventtype [ text]  careunit [ text]  wardid [ number]  intime [ time]  outtime [ time] 
SELECT (SELECT chartevents.valuenum FROM chartevents WHERE chartevents.icustay_id IN (SELECT icustays.icustay_id FROM icustays WHERE icustays.hadm_id IN (SELECT admissions.hadm_id FROM admissions WHERE admissions.subject_id = 4092)) AND chartevents.itemid IN (SELECT d_items.itemid FROM d_items WHERE d_items.label = 'heart rate' AND d_items.linksto = 'chartevents') AND chartevents.charttime = '2104-07-02 11:00:00') - (SELECT chartevents.valuenum FROM chartevents WHERE chartevents.icustay_id IN (SELECT icustays.icustay_id FROM icustays WHERE icustays.hadm_id IN (SELECT admissions.hadm_id FROM admissions WHERE admissions.subject_id = 4092)) AND chartevents.itemid IN (SELECT d_items.itemid FROM d_items WHERE d_items.label = 'heart rate' AND d_items.linksto = 'chartevents') AND chartevents.charttime = '2104-07-02 05:00:00')