-- count people who said "a" on exam 1,question 20 and
--                       "c" on exam 43, question 37:
select count(*) from the_table where exam_id=1 and answer20='a' and 
  student_id in (select student_id from the_table where
                 exam_id=43 and answer37='c')