Write the DML select statements to create the following reports:

20.

A. Find the name and phone number of each vendor who has a cooperating vendor. Hint: the vendors for whom the field Cooperating_Vendor_id is not empty B. Now find additionally the name and phone number of the cooperating vendor. Present these two columns as: cooperating vendor and cooperating vendor phone. C. Modify the above query to report all vendors. If they are have a cooperating vendor, report their name if not report N/A.

21.

A. Find the average invoice_total using INVOICES name this quantity total_avg B. Now find the average invoice_total per vendor, name this quantity vendor_avg C. Now find the vendors with average invoice total larger than total_avg D. Now find the vendors with an invoice total larger than total_avg

Connections Connections * + - Y O CUSTOMERS CUSTOMER_ID CUSTOMER_FIRST_NAME CUSTOMER_LAST_NAME 1 CUSTOMER_ADDRESS 1 CUSTOMER_CITY CUSTOMER_STATE CUSTOMER_ZIP CUSTOMER_PHONE CUSTOMER_FAX + CUSTOMERSHIP ADDRESS_T + DOESBUSINESSINT + EMPLOYEET + EMPLOYEESKILLS T +- GENERAL_LEDGER_ACCOUNTS + INVOICE_LINE_ITEMS #- INVOICES ITEMS ORDER_DETAILS ORDER_ID ITEM_ID ORDER_QTY --DORDER_T ORDERID CUSTOMERID ORDERDATE FULFILLMENTDATE SALESPERSONID SHIPADRSID # E ORDERLINET # E ORDERS + PAYMENT_T - PAYMENTTYPE_T OD PAYMENT_T PAYMENTID ORDERID PAYMENTTYPEID PAYMENTDATE PAYMENTAMOUNT PAYMENTCOMMENT + PAYMENTTYPE_T + PRODUCEDIN_T PRODUCT_T PRODUCTID IT PRODUCTLINEID PRODUCTDESCRIPTION PRODUCTFINISH PRODUCTSTANDARDPRICE PRODUCTONHAND # PRODUCTLINET # SALESPERSON_T + SKILL_T + TERMS # TERRITORY_T VENDOR_CONTACTS VENDOR_ID LAST_NAME FIRST_NAME BEVENDORS VENDOR_ID VENDOR_NAME VENDOR_ADDRESS1 I VENDOR_ADDRESS2 VENDOR_CITY VENDOR_STATE TRIGLIS QY PRODUCT_T PRODUCTID PRODUCTLINEID PRODUCTDESCRIPTION PRODUCTFINISH PRODUCTSTANDARDPRICE PRODUCTONHAND # - PRODUCTLINE_T # SALESPERSON_T + SKILL_T + TERMS + TERRITORY VENDOR_CONTACTS VENDOR_ID LAST_NAME FIRST_NAME VENDORS VENDOR_ID VENDOR_NAME VENDOR_ADDRESS1 VENDOR_ADDRESS2 VENDOR_CITY VENDOR_STATE VENDOR_ZIP_CODE VENDOR_PHONE VENDOR_CONTACT_LAST_NAME VENDOR_CONTACT_FIRST_NAME DEFAULT_TERMS_ID DEFAULT_ACCOUNT_NUMBER COOPERATING_VENDOR_ID # WORKCENTER_T # WORKSINT # Views Connections + CRY DMS Lab 2 DMS Lab 3 Tables (Filtered) + CUSTOMER_T # CUSTOMERS + CUSTOMERSHIP ADDRESS_T + DOESBUSINESSIN_T + EMPLOYEET # 2 EMPLOYEESKILLST + GENERAL_LEDGER_ACCOUN + INVOICE_LINE_ITEMS # INVOICES + DITEMS # D ORDER_DETAILS + ORDER_T + ORDERLINET + ORDERS + E PAYMENT_T + PAYMENTTYPET + PRODUCEDIN_T + PRODUCT_ # PRODUCTLINET + SALESPERSON_T + SKILLT # TERMS + D TERRITORY # E VENDOR_CONTACTS + E VENDORS # D WORKCENTER_T # WORKSIN_T Views 109 Editioning views