Answered You can hire a professional tutor to get the answer.

QUESTION

Employee OrderID CustomerDo LastName CustomerID CompanyName FirstName EmployeeID ContactName Title OrderDate Contact Title Title OfCourtesy Required

Hello, I am learning postgreSQL and the following is my assignment. My question is below the schema. Thanks for any help you can provide.

This is my schema.

I have been

My task is to submit a SQL query that lists employee IDs who serve the same customer, along with the customer ID. The first several rows of output of your query should look like the following:

I have been able to figure out basic queries that will show me employees and the customers they worked with but I have not been able to figure out how to show employees who serve the same customer.

Thank you for any help you can provide.

  • Attachment 1
  • Attachment 2
EmployeeOrderIDCustomerDoLastNameCustomerIDCompanyNameFirstNameEmployeeIDContactNameTitleOrderDateContact TitleTitle OfCourtesyRequired DateAddressBirth DateShipped DateCityHire DateShipViaRegionAddressFreightPostalcodeCityShip NameShipper IDCountryRegionShip AddressCompany NamePhonePostalcodeShip CityPhoneFoxCountryShipRegionHomephoneShippostal CodeExtensionShip CountryPhotoNotesSuppber IDReports ToCompany NameProductIDContactNameProductNameContact TitleSupplierIDAddressCategoryIDCityProductQuantity PerUnitRegionUnitpriceCategory IDPostalcodeUnitpriceUnitsInStockCategory NameCountryQuantityUnits OnordeDescriptionPhoneDiscountReorderLevelPictureFaxDiscontinuedHome Page
Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question