INSERT INTO evaluation_reports (student_id, term_id, teacher_id, teacher_evaluation,student_evaluation) VALUES (27, 29, 9, 'Chinkemka is an enthusiastic learner who exhibits positive outlook and attitude in the classroom. He appears well rested and ready for each day’s activities. He is smart, confident, bold, and eager to learn. He is one of the neatest students in the class. He is a talented football player and House Captain (male house prefect) of Xavier House. However, he needs to be more aware of his responsibilities and focus on his studies. He should concentrate more during class learning rather than distracting himself and his peers.', 'This term has not been that good, I find some subjects challenging, but I still try to pass them. My goal this term was to enter merit but I did not achieve that but I hope that I will enter merit and make my parents proud. I lost a lot of friends this term, I am not close to a lot of people but I hope that I would be able to get close to my friends again. My goal is to enter merit and I am going to get into merit to make myself and my parents proud.') ON DUPLICATE KEY UPDATE teacher_evaluation = 'Chinkemka is an enthusiastic learner who exhibits positive outlook and attitude in the classroom. He appears well rested and ready for each day’s activities. He is smart, confident, bold, and eager to learn. He is one of the neatest students in the class. He is a talented football player and House Captain (male house prefect) of Xavier House. However, he needs to be more aware of his responsibilities and focus on his studies. He should concentrate more during class learning rather than distracting himself and his peers.', student_evaluation = 'This term has not been that good, I find some subjects challenging, but I still try to pass them. My goal this term was to enter merit but I did not achieve that but I hope that I will enter merit and make my parents proud. I lost a lot of friends this term, I am not close to a lot of people but I hope that I would be able to get close to my friends again. My goal is to enter merit and I am going to get into merit to make myself and my parents proud.',  teacher_id = 9 