MYSQL - 从多行，相同用户，不同值中选择

Below is my table called fittest. I need to find which students based on student id (studid) have taken the pre and post test as designated in the prepost column. So based on the simple table below I would need to return studid 123456. How do I write the SELECT query for this?Below is my table called fittest. I need to fin