SET ECHO ON;
SELECT INVOICE.INV_NUMBER, SUM(LINE_PRICE)
FROM INVOICE, LINE
GROUP BY INVOICE.INV_NUMBER
ORDER BY INV_NUMBER DESC;