Page 1 of 1

Program + Semester CET III Summer 2022 Course Instructor Muhammad Waqar Aslam Course Name Database Management invoice_nu

Posted: Sun Jul 10, 2022 11:30 am
by answerhappygod
Program Semester Cet Iii Summer 2022 Course Instructor Muhammad Waqar Aslam Course Name Database Management Invoice Nu 1
Program Semester Cet Iii Summer 2022 Course Instructor Muhammad Waqar Aslam Course Name Database Management Invoice Nu 1 (30.92 KiB) Viewed 60 times
Program + Semester CET III Summer 2022 Course Instructor Muhammad Waqar Aslam Course Name Database Management invoice_number invoice_date balance_due payment_date Type of Evaluation Assignment # 4 Due Date Week 9 (July 9, 2022) Section Code IN3193-64 Percentage Weight of Total Evaluation 8% Total Marks: Student Name: Question No. 1 (Marks 3) Write a SELECT statement that returns these columns from the Invoices table: Name Description Page 1 of 1 Student ID#: /8 The invoice number column The invoice_date column The invoice total column minus the payment total and credit total columns The payment_date column 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.