Code example $7-1$

SELECT vendor$\_$name, COUNT$(*)$ AS number$\_$of$\_$invoices,

MAX$($invoice$\_$total $-$ payment$\_$total $-$ credit$\_$total$)$ AS balance$\_$due

FROM vendors v

JOIN invoices i

ON v$.$vendor$\_$id $=$ i$.$vendor$\_$id

WHERE invoice$\_$total $-$ payment$\_$total $-$ credit$\_$total $>$

$($SELECT AVG$($invoice$\_$total $-$ payment$\_$total $-$ credit$\_$total$)$

FROM invoices$)$

GROUP BY vendor$\_$name

ORDER BY balance$\_$due DESC

$($Refer to code example $7-1.)$ When this query is executed, the rows will be sorted by$...$

Group of answer choices

invoice$\_$id

vendor$\_$id

balance$\_$due in descending sequence

vendor$\_$id and then by balance$\_$due in descending sequence