Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Microsoft SQL Question. Write a query that will show the Customer Last Name (CUST_LAST), invoice number, the invoice amount, the minimum invoice amount, and the
Microsoft SQL Question.
Write a query that will show the Customer Last Name (CUST_LAST), invoice number, the invoice amount, the minimum invoice amount, and the differences between the minimum invoice amount and the actual invoice amount.
CUSTOMER CUST_NUM CUST_LAST - 100 Brown 101 Smith 102 Ortega 0 CUST_FNAME Sam Jean Juan CUST_BALANCE 1650.16 940.16 648.97 0.00 DOB Click to Add 10/2/1892 5/25/1996 11/21/1998 INVOICE INV_NUM Field 1 Click to CUSTOMER_NUM 9000 101 9001 100 9002 100 0 0 INV_DATE 23-Mar-16 24-May-16 30-May-16 INV_AMOUNT 235.16 $12.16 528.16 0.00 Record: + 2 of 3 No Filter SearchStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started