EssayNICE | 24/7 Homework Help

Essaynice Will Help You Write Your Essays and Term Papers

Answered » You can buy a ready-made answer or pick a professional tutor to order an original one.

Assignment help 8303

by | Jun 24, 2023 | Posted Assignments

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


Why Place An Order With Us?

  • Certified Editors
  • 24/7 Customer Support
  • Profesional Research
  • Easy to Use System Interface
  • Student Friendly Pricing

Have a similar question?


All papers we provide are well-researched, properly formatted and cited.


All papers we provide are well-researched, properly formatted and cited.


All papers we provide are well-researched, properly formatted and cited.

Open chat
Powered by essaynice
Hello! Welcome to to our whatapp support.
We offer READY solutions, HIGH QUALITY PLAGIARISM FREE essays and term-papers.

We are online and ready to help