SQL queries 1 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 2 A Find the order date for all the orders of customers who leave in Los Angeles using joins B Repeat the same query this time using non correlated subqueries C Repeat the same query this time using correlated subqueries with the IN statement D Repeat the same query this time using WHERE EXISTS VENDOR CONTACTS 1 VENDOR ID LAST NAME FIRST NAME VENDORT VENDORS I VENDOR ID I VENDOR NAME 1 VENDOR ADDRESS1 0 VENDOR ADDRESS2 VENDOR CITY 1 VENDOR STATE VENDOR ZIP CODE I VENDOR PHONE 1 VENDOR CONTACT LAST NAME O VENDOR CONTACT FIRST NAME DEFAULT TERMS ID DEFAULT ACCOUNT NUMBER O COOPERATING VENDOR ID CUSTOMERS O CUSTOMER ID 1 CUSTOMER FIRST NAME 1 CUSTOMER LAST NAME CUSTOMER ADDRESS CUSTOMER CITY 1 CUSTOMER STATE 1 CUSTOMER ZIP 1 CUSTOMER PHONE CUSTOMER FAX CUSTOMERSHIPADDRESS T DOESBUSINESSIN T EMPLOYEE T EMPLOYEESKILLS T GENERAL LEDGER ACCOUNTS INVOICE LINE ITEMS INVOICES ITEMS ORDER DETAILS ORDER T ORDERLINE T ORDERS 11 ORDER ID 1 CUSTOMER ID ORDER DATE 1 SHIPPED DATE

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 26, 2024

SQL queries: 1. A. Find the name and phone number of each vendor who has a cooperating vendor. Hint: the vendors for whom the field

SQL queries:

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

2. A. Find the order date for all the orders of customers who leave in Los Angeles using joins

B. Repeat the same query this time using non-correlated subqueries

C. Repeat the same query this time using correlated subqueries with the IN statement D. Repeat the same query this time using WHERE EXISTS

image text in transcribed

VENDOR_CONTACTS 1 VENDOR_ID LAST_NAME FIRST_NAME VENDORT VENDORS I VENDOR_ID I VENDOR_NAME 1 VENDOR_ADDRESS1 0 VENDOR_ADDRESS2 | VENDOR_CITY 1 VENDOR_STATE - VENDOR_ZIP_CODE I VENDOR_PHONE 1 VENDOR_CONTACT_LAST_NAME O VENDOR_CONTACT_FIRST_NAME - DEFAULT_TERMS_ID DEFAULT_ACCOUNT_NUMBER O COOPERATING_VENDOR_ID CUSTOMERS O CUSTOMER_ID 1 CUSTOMER_FIRST_NAME 1 CUSTOMER_LAST_NAME - CUSTOMER_ADDRESS - CUSTOMER_CITY 1 CUSTOMER_STATE 1 CUSTOMER_ZIP 1 CUSTOMER_PHONE CUSTOMER_FAX CUSTOMERSHIPADDRESS_T DOESBUSINESSIN_T EMPLOYEE_T EMPLOYEESKILLS_T GENERAL_LEDGER_ACCOUNTS INVOICE_LINE_ITEMS INVOICES ITEMS ORDER_DETAILS ORDER_T ORDERLINE_T ORDERS 11 ORDER_ID 1 CUSTOMER_ID - ORDER_DATE 1 SHIPPED_DATE