SQL query to fetch absence data

Summary:

Hi all,

My requirement is to fetch below data, I am using below query but it is not giving the exact data. I need to fetch the last row that is absence (-9.89).

Can someone please help me on fixing the query or guide me to the correct table.

Thanks

Content (please ensure you mask any confidential information):

SQL Query Used:

SELECT peo.person_number emp_id, aapft.NAME absence_plan_name,
sum(acc_ent.USED)
FROM per_all_people_f peo,
per_all_assignments_f asg,
per_person_names_f per_name,
per_periods_of_service ser,
per_person_types_tl per_typ,