Write the DML select statements to create the following reports:

1. Find the distinct names of the vendors who have invoices with invoice_total larger than 10,000. Rewrite the above query in a total of 3 ways: A. Using equijoins B. using INNER JOIN and C. using NATURAL JOIN

5. A. Find the vendor_name and the invoice_number for the vendors who have invoices, but only for those invoices that have valid invoicelines. B. Find the vendor_id and the corresponding invoice_id for the vendors who have invoices, even if these invoices do not have valid invoicelines. C. Find the vendor_id and the corresponding invoice_id for all the vendors, even the ones with no invoices, even if these invoices do not have valid invoicelines.

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 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