Question: Write a mysql script that creates and calls a stored procedure named test. THis procedure should create a cursor for a result set consists of

Write a mysql script that creates and calls a stored procedure named test. THis procedure should create a cursor for a result set consists of the vendor_name, invoice_number, and balance_due which is (invoice_total - payment_due - credits_due) with a balance due greater than or equal to 5,000,

The results should be sorted in decending sequence by balance due.

The invoice data should be placed in 3 groups based on the balance due, 20,000, or more, 10,000 - 20,000 or 5-10,000.

When your done the string variable thats returned should be in this format:

20,000 more more: 10,000 to 20,000: 11130.70|P-0680|Malloy Lithographing INC// 5,000 to 10,000: 6586.62|O-2436|Malloy Lithographing INC//

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!