Database: online_exams
Question: Which student answer texts were given 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"