We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
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.
The Report
You are viewing a single comment's thread. Return to all comments →
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.