คลาส 746 สอนโดย ศ.เบธ วิลเลนสกี้ กี่ครั้ง ?ไม่จำเป็นต้องใช้โต๊ะทั้งหมด
Class 746 has been taught by Prof. Beth Wilensky how many times ?It is not neccessary to use all the tables.
 course:  course_id [ int]  name [ varchar]  department [ varchar]  number [ varchar]  credits [ varchar]  advisory_requirement [ varchar]  enforced_requirement [ varchar]  description [ varchar]  num_semesters [ int]  num_enrolled [ int]  has_discussion [ varchar]  has_lab [ varchar]  has_projects [ varchar]  has_exams [ varchar]  num_reviews [ int]  clarity_score [ int]  easiness_score [ int]  helpfulness_score [ int] 
SELECT COUNT(*) FROM course, course_offering, instructor, offering_instructor WHERE course.course_id = course_offering.course_id AND course.number = 746 AND instructor.name LIKE '%Beth Wilensky%' AND offering_instructor.instructor_id = instructor.instructor_id AND offering_instructor.offering_id = course_offering.offering_id