Course Solutions Uncategorized (Solved) : Description Database Select Active Source Invoicenumber Invoicedate Invoicetotal Activeinv Q30457062 . . . .

(Solved) : Description Database Select Active Source Invoicenumber Invoicedate Invoicetotal Activeinv Q30457062 . . . .

 

What is the description of this database

SELECT ‘Active’ ASsource’invoice_number,invoice_date,invoice_total

FROM active_invoices

WHERE invoice_date>=‘2014-06-01’

        UNION

        SELECT ‘Paid’ ASsource,invoice_number,invoice_date,invoice_total

        FROMPaid_invoices

        WHEREinvoice_date>= ‘2014-06-01’

        ORDER BYinvoice_total DESC

Expert Answer


An answer will be send to you shortly. . . . .

Leave a Reply

Your email address will not be published. Required fields are marked *

Related Post