Report: Generate a report with the names of customers who spent the most money (top 3) so

Fantastic news! We've Found the answer you've been seeking!

Question:

Report: Generate a report with the names of customers who spent the most money (top 3) so we can send them discount coupons, and also the names of the most frugal customers (bottom 3). Feature 19: Report names of customers who spent the most money. Input: Create a function with Cust_Name, Amount_Paid, Tip, Cust_Credit_Card, Cust_email (join) followed by a procedure and a cursor to store the select statement output into the cursor. Output: Displays the 3 names of customers with the highest amount_paid and 3 names of customers with the lowest amount_paid using the cursor. Example of calling the feature:

Exec customer_spending(customers.Cust_name, customers.Cust_Credit_Card_Num, orders.amount_paid, orders.tip);