1. Write a query to find minimum customer balance, maximum customer balance and average customer balance.

2. Write a query to find all customers with a balance of more than $300 but less than $1000. Sort the results by customer balance (highest first).

3. Write a query to find out the name of the vendor who supplied the product with product code 11QER/31.

4. Write a query to generate first name, last name of customers along with invoice number and invoice date where invoice date is between January 15 and January 18, 2018.

5. Generate a listing of all purchases made by the customers. Sort the results by customer code, invoice number, and product description.

6. Write a query to produce the total purchase by invoice sorted by invoice number.

contains - generates CUSTOMER PK CUS_CODE CUS_LNAME CUS FNAME CUS_INITIAL CUS AREACODE CUS PHONE CUS_BALANCE INVOICE PKINY NUMBER FK1CuS_CODE INV_DATE LINE PK,FK1INY NUMBER PK LINE NUMBER FK2 P CODE LINE_UNITS LINE PRICE is found in VENDOR PK V_CODE supplies 0 V_NAME V CONTACT HO- V_AREACODE V PHONE V_STATE V ORDER PRODUCT PK L_CODE P_DESCRIPT P_INDATE P QOH P MIN P PRICE P_DISCOUNT FK1V_CODE