4. Enhance your solution to exercise 3 so it shows the invoice data in three gro

Question

4. Enhance your solution to exercise 3 so it shows the invoice data in three groups based on the balance due amounts with these headings: You will use the CURSOR three different times to loop through using the different criteria as defined below with the headings. $20,000 or More $10,000 to $20,000 $5,000 to $10,000 Each group should have a heading followed by the data for the invoices that fall into that group. Also, the groups should be separated by one blank line.

5. Enhance your solution to exercise 3 so it uses a substitution variable to set a bind variable that you use to determine what the minimum balance due should be for the invoices that the SELECT statement is going to retrieve. You should also use this bind variable to display a heading like this before the list of invoices: You are using the bind variable to set the balance due minimum. In this case 2000 is not a hard coded value but is set using a bind variable. Invoice amounts greater than or equal to $2,000 ================================================== where 2,000 is the value of the bind variable.

Explanation / Answer

hi,

please find the solution SQL below

SELECT "Sheet1"."Customer" AS "Customer", "Sheet1"."Type" AS "Type", "Sheet1"."Num" AS "Num", "Sheet1"."Date" AS "Date", MONTH( "Sheet1"."RealDate" ) AS "Month", "Sheet1"."Total" AS "Total" FROM "Sheet1" "Sheet1" WHERE "Customer" <> '' ORDER BY "Sheet1"."Customer", "Num"

Related Questions

Navigate

• Browse (All)
• Browse 4
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.