Please answer using SQL :) /* Query 1 What are the employees responsible for a sale (last name only), the ID of the orde

[answerhappygod]

Please answer using SQL
/*
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
, , , , and , respectively
*/
#DELETE THIS LINE AND PASTE YOUR QUERY HERE
/*
Query 6
What is the total order price for each order
listed in Northwind's database?
Include the Customer ID and Shipping Name for each
order and sort the output by Customer ID
*/
#DELETE THIS LINE AND PASTE YOUR QUERY HERE
/*
Query 7
Add to the previous query. Include the Title of
Courtesy, First Name, and Last Name of the
Northwind employee responsible for each sale. Sort
the output by the responsible employee's last name.
*/
#DELETE THIS LINE AND PASTE YOUR QUERY HERE

Please Answer Using Sql Query 1 What Are The Employees Responsible For A Sale Last Name Only The Id Of The Orde 1 (173.59 KiB) Viewed 30 times

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