multiple matching records sorting problem

hi i have two tables
students and attendance tables
foreign key in attendence multi matching records relationship
listing students and want to see each attendence per students
Janny 12
Mat 2
Alex 5
attendance until here i can make it with goup forign key of attendence but i cannot make sorting my attendce from higher lower or from lower to hgher

Estudiantes fields to retrieve
SUM(Students.attendence _number):Students.attendence_total
​
if i connect one to one this pagination shows like that too many pages blank
if i connect multiple relationship then pagionation works well but i caanot use Students.attendence_total for sorting
i dont know how to solve this
​

​

​