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
How it Works
It only takes a couple of minutes to fill in your details, select the type of paper you need (essay, term paper, etc.), give us all necessary information regarding your assignment.
Once we receive your request, one of our customer support representatives will contact you within 24 hours with more specific information about how much it'll cost for this particular project.
After receiving payment confirmation via PayPal or credit card – we begin working on your detailed outline, which is based on the requirements given by yourself upon ordering.
Once approved, your order is complete and will be emailed directly to the email address provided before payment was made!