2 Create Self Join Returns Vendors Cities Common Vendors Find Correct Murach Schema Write Q37033399

2. Create a self join that returns vendors from cities in commonwith other vendors. Find the correct murach schema then write andtest the statement.  

3. Join vendors and invoices tables that have the same vendornumber. Print the result set that has the invoice_number andvendor_name. Order by invoice_number.

Answer