Answer Happy

Name Question No. 1 (Marks 3) Write a SELECT statement that returns these columns from the Invoices table: invoice_number invoice_date balance_due payment_date Description Open with Student ID #. The invoice_number column The invoice_date column The invoice_total column minus the payment_total and credit_total columns The payment_date column Page Result should be sorted by balance_due descending. Return only the rows where the payment_date column contains a null value. This should retrieve 11 rows. Please show a screenshot of the executed query.
Question No. 2 (Marks 5) Write a SELECT statement that returns one column from the Vendors table named vendor_address that joins the vendor_address1 and vendor_address2 columns. Format this column with the vendor_address1, one space, four dashes (---), one space and the vendor_address2 like this: Attn: Supt. Window Services Sort the result set by vendor_name in ascending sequence. Return only those rows where vendor_address1 and vendor_address2 are not null and vendor_address2 must start with 'P'. This should give 9 rows. Please show a screenshot of the executed query. ---- PO Box 7005 I