We have two student tables with details in one table and marks in another, we need to calculate the percentage of marks obtained by students and divide them according to percentage and gender. Attached image for further understanding.