นับจำนวนผู้ป่วยที่ปีที่เข้ารับการรักษาน้อยกว่า 2,180 และชื่อยาคือเซฟาโซลิน?ไม่จำเป็นต้องใช้ทุกตาราง
count the number of patients whose admission year is less than 2180 and drug name is cefazolin?It is not neccessary to use all the tables.
 demographic:  subject_id [ text]  hadm_id [ text]  name [ text]  marital_status [ text]  age [ text]  dob [ text]  gender [ text]  language [ text]  religion [ text]  admission_type [ text]  days_stay [ text]  insurance [ text]  ethnicity [ text]  expire_flag [ text]  admission_location [ text]  discharge_location [ text]  diagnosis [ text]  dod [ text]  dob_year [ text]  dod_year [ text]  admittime [ text]  dischtime [ text]  admityear [ text] 
SELECT COUNT(DISTINCT demographic.subject_id) FROM demographic INNER JOIN prescriptions ON demographic.hadm_id = prescriptions.hadm_id WHERE demographic.admityear < "2180" AND prescriptions.drug = "CefazoLIN"