How can I select the student whose first assignment's grade is lower than that of his assignment 2 and 3 from the following table?


student course assignment grade
1 c1 1 76
1 c1 2 78
1 c1 3 85
2 c2 1 98
2 c2 2 78
2 c3 1 87
2 c3 2 29
.......

Thank you