Database: cre_Students_Information_Systems
Question: For each student, find the student id and the total amount of loan he or she has.
SQL:
SELECT student_id ,  sum(amount_of_loan) FROM Student_Loans GROUP BY student_id