- Suppliers Supplierid Companyname Contactname Contacttitle Address City Region Postalcode Country Phone Fax Homepage Cate 1 (173.59 KiB) Viewed 33 times
Query 1
What are the employees responsible for a sale
(last name only), the ID of the order, the shipping name,
shipping country, and shipping fee for orders
placed to ship to customers in the UK and Ireland?
Sort these results by employee last name. Also,
for readability purposes format the field names as
“Employee Last Name”, “Order ID”, “Freight
Company”, “Destination Country”, and “Shipping Cost”,
respectively
*/
Suppliers SupplierID CompanyName ContactName ContactTitle Address City Region PostalCode Country Phone Fax HomePage Categories CategoryID CategoryName Description Picture Products ProductID ProductName Supplier D CategoryID QuantityPerUnit UnitPrice UnitsInStock UnitsOnOrder ReorderLevel Discontinued OrderDetails OrderID ProductID UnitPrice Quantity Discount Employees EmployeelD LastName FirstName Title TitleOfCourtesy BirthDate HireDate Address City Region Postal Code Country HomePhone Extension Photo Notes ReportsTo 1 Orders OrderID CustomerID EmployeelD OrderDate RequiredDate ShippedDate ShipVia Freight ShipName ShipAddress ShipCity ShipRegion ShipPostalCode ShipCountry Customers ử CustomerID CompanyName ContactName ContactTitle Address City Region PostalCode Country Phone Fax Shippers ShipperID CompanyName Phone