ปริซึมเสตครั้งแรก (b32 k2) ในปี 11/ปีที่แล้ว ฉีดให้กับผู้ป่วย 92063 ในปริมาณเท่าใด? ไม่จำเป็นต้องใช้ตารางทั้งหมด
what was the first dose of prismasate (b32 k2) in 11/last year, prescribed to patient 92063?It is not neccessary to use all the tables.
 icustays:  row_id [ number]  subject_id [ number]  hadm_id [ number]  icustay_id [ number]  first_careunit [ text]  last_careunit [ text]  first_wardid [ number]  last_wardid [ number]  intime [ time]  outtime [ time] 
SELECT prescriptions.dose_val_rx FROM prescriptions WHERE prescriptions.hadm_id IN (SELECT admissions.hadm_id FROM admissions WHERE admissions.subject_id = 92063) AND prescriptions.drug = 'prismasate (b32 k2)' AND DATETIME(prescriptions.startdate, 'start of year') = DATETIME(CURRENT_TIME(), 'start of year', '-1 year') AND STRFTIME('%m', prescriptions.startdate) = '11' ORDER BY prescriptions.startdate LIMIT 1