instruction: What are the grades I 've received in classes taught by Prof. Farmer ?
response: SELECT DISTINCT student_record.grade FROM student_record INNER JOIN offering_instructor ON student_record.offering_id = offering_instructor.offering_id INNER JOIN instructor ON offering_instructor.instructor_id = instructor.instructor_id WHERE LOWER(instructor.name) LIKE '%Farmer%' AND student_record.student_id = 1