(This is from the northwinds data base so make sure you reference it as so in yo

Question

(This is from the northwinds data base so make sure you reference it as so in your answer)

List customer id, employee id, order id and order date for orders shipped to Bottom-Dollar Markets which were not sold by employee numbers 3, 4, 5 or 6. Order the list by order id within employee.

Suppliers Company Name ContactName Contact Title Address Reg on PostalCode try Phone Categories Category ID Category Name Description Products ProductName pplierI Cat ID Quantity PerUnit tPrice Unit Cost Units InStock Ord itsOn er ReorderLevel Discontinued Order Deta Orders too 1. Order ID OrderID Customer ID EmployeeID Unit Pric OrderDate Quantity RequiredDate Shippe ate hipWi Employees Freight ShipName LastName Ship Address FirstName ShipCit tle ShipRegion TitleOf Courtesy ShippostalCode BirthDate Ship Country HireDate Address ity Region PostalCode Country HomePhone Extension otes Reports Customers Customer ID Company Name Contact Name Conta ctTi tle Address City Regio PostalCode Country Phone Fax Shippers Shipper ID Company Name Phone

Explanation / Answer

in our ques we customer id, employee id, order id and order date and since all these fields are present in Orders table so we only require single table

Select O.CustomerID, O.EmployeeID, O.OrderID, O.OrderDate from Orders O where O.EmployeeID not in (3,4,5,6) and O.ShipAddress =’ Bottom-Dollar Markets ’ order by O.EmployeeID , O.OrderID

Related Questions

Navigate

• Browse (All)
• Browse #
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.