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 Search