Assume that a single person may have any number of loans $($including zero$),$ and a loan must be paid in full on

the stipulated end date.

What will the following query return?

SELECT

p$.$person$\_$id$,$

p$.$full$\_$name,

SUM$($CASE WHEN $1.$end$\_$date $$ CURRENT$\_$DATE THEN $1.$amount ELSE $0$ END$)$ AS total

FROM people p

JOIN loans $1$ ON p$.$person$\_$id $=1.$person$\_$id AND $1.$is$\_$paid$\_$out $=$ FALSE

GROUP BY p$.$person$\_$id$,$ p$.$full$\_$name

The list of people who have only remaining payments with the sum of their remaining payments.

The list of people who have only overdue payments with the sum of their overdue payments.

The list of people who have overdue and$/$or remaining payments with the sum of their overdue

payments.

The list of all people with the sum of their remaining payments.