นับจำนวนครั้งที่ผู้ป่วย 006-66039 ได้รับ po po จนถึงวันที่ 11/08/2103 ไม่จำเป็นต้องใช้ตารางทั้งหมด
count the number of times that patient 006-66039 had had an po po intake until 08/11/2103.It is not neccessary to use all the tables.
 lab:  labid [ number]  patientunitstayid [ number]  labname [ text]  labresult [ number]  labresulttime [ time] 
SELECT COUNT(*) FROM intakeoutput WHERE intakeoutput.patientunitstayid IN (SELECT patient.patientunitstayid FROM patient WHERE patient.patienthealthsystemstayid IN (SELECT patient.patienthealthsystemstayid FROM patient WHERE patient.uniquepid = '006-66039')) AND intakeoutput.cellpath LIKE '%intake%' AND intakeoutput.celllabel = 'po po' AND STRFTIME('%y-%m-%d', intakeoutput.intakeoutputtime) <= '2103-08-11'