อาจารย์คนไหนให้คะแนน B- แก่ผู้เยาว์ PSYCH ในชั้นเรียน ?ไม่จำเป็นต้องใช้ตารางทั้งหมด
Which professors have given PSYCH minors a B- in their class ?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 DISTINCT instructor.name FROM instructor INNER JOIN offering_instructor ON offering_instructor.instructor_id = instructor.instructor_id INNER JOIN student_record ON student_record.offering_id = offering_instructor.offering_id INNER JOIN student ON student.student_id = student_record.student_id WHERE (student_record.grade LIKE '%B-%' OR student_record.grade LIKE '%B-%') AND student.minor = 'PSYCH'