Name Question No 1 Marks 3 Write A Select Statement That Returns These Columns From The Invoices Table Invoice Numbe 1 (73.65 KiB) Viewed 43 times
Name Question No 1 Marks 3 Write A Select Statement That Returns These Columns From The Invoices Table Invoice Numbe 2 (109.76 KiB) Viewed 43 times
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
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!