Database: online_exams
Question: Show the student answer texts that received both "Normal" and "Absent" as comments.
SQL:
SELECT Student_Answer_Text FROM Student_Answers WHERE Comments  =  "Normal" INTERSECT SELECT Student_Answer_Text FROM Student_Answers WHERE Comments  =  "Absent"