You are viewing a single comment's thread. Return to all comments →
Why the "ON s.marks BETWEEN min_mark AND max_mark" line? Could you explain please.
We have to determine the grade of the student based on the scored marks. So to achieve that, we need to consider the range of marks for a particular grade which is defined in the grades table as min_mark and max_mark.
By "ON s.marks BETWEEN min_mark AND max_mark" we are defining the range of the marks for a particular grade and performing the join operation.