Hi,

To fetch the total loan_amount group by employees, you can use the following query:

SELECT SUM(loan_amount)
FROM hr_loan
GROUP BY employee_id;

This will display the results in the following format:

Sum 

4687.50
23963.00
750.00
2145.00
3325.00

If you want to fetch the loan_amount for a specific employee, you can add the employee ID in the WHERE condition like this:

SELECT SUM(loan_amount) 
FROM hr_loan 
WHERE employee_id = 10;

This will display the result like 2145.00.

Regards