Database: cre_Students_Information_Systems
Question: How much total loan does each student have ? List the student ids and the amounts .
SQL:
select student_id ,  sum(amount_of_loan) from student_loans group by student_id