สำหรับ 542 ศาสตราจารย์เพลแฮม บาร์รอน สอนกี่ครั้ง ?ไม่จำเป็นต้องใช้โต๊ะทั้งหมด
For 542 , how many times has Prof. Pelham Barron taught ?It is not neccessary to use all the tables.
 student:  student_id [ int]  lastname [ varchar]  firstname [ varchar]  program_id [ int]  declare_major [ varchar]  total_credit [ int]  total_gpa [ float]  entered_as [ varchar]  admit_term [ int]  predicted_graduation_semester [ int]  degree [ varchar]  minor [ varchar]  internship [ varchar] 
SELECT COUNT(*) FROM course, course_offering, instructor, offering_instructor WHERE course.course_id = course_offering.course_id AND course.number = 542 AND instructor.name LIKE '%Pelham Barron%' AND offering_instructor.instructor_id = instructor.instructor_id AND offering_instructor.offering_id = course_offering.offering_id