Program Semester CETI Course Name Database Management invoice number invoice_date balance due payment date Type of Evalu

[answerhappygod]

Program Semester Ceti Course Name Database Management Invoice Number Invoice Date Balance Due Payment Date Type Of Evalu 1 (26.91 KiB) Viewed 22 times

Program Semester CETI Course Name Database Management invoice number invoice_date balance due payment date Type of Evaluation Assignment #4 Section Code NI3-6) Summer 2022 Course Instructor Muhammad Wagar Aslam Student Name Question No. 1 (Marks 3) Write a SELECT statement that returns these columns from the invoice table Description The invoice number column The invoice date column Due Date Week 9 (July 11, 2022) Percentage Weight of Total Evaluation Total Mark Student ID The invoice total column minus the payment total and credit total columna The payment date column /8 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 address, one space, four dashes, one space and the vendor address like this: Attr: Supt. Window Services PO Box 7005 Sort the result set by vendor name in ascending sequence Return only those rows where vendor address and vendor address2 must start with P This should give 9 rows. Please show a screenshot of the executed query null and vendor_address2