CREATE OR REPLACE VIEW invoices_outstanding
(invoice_number, invoice_date, invoice_total,
balance_due)
AS
SELECT invoice_number, invoice_date, invoice_total,
invoice_total - payment_total - credit_total
FROM invoices
WHERE invoice_total - payment_total - credit_total > 0
Since the “AS” command has been overloaded here to perform a different function, How would you gain control over the column names for you view?
The answer is that they are listed (as shown in red) before the AS command