Answer Happy

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 2
How many customers does Northwind have in each country in
which they do business?
*/
#DELETE THIS LINE AND PASTE YOUR QUERY HERE
/*
Query 3
What prouducts sold by Northwind have a unit price more than
$20 but less than $50 and are currently in stock?
*/
#DELETE THIS LINE AND PASTE YOUR QUERY HERE
/*
Query 4
How many of Northwind's customers are explicitly identified
as "Manager" in their job title?
Show the individual count for all of the various "Manager"
titles.
*/
#DELETE THIS LINE AND PASTE YOUR QUERY HERE
/*
Query 5
How many of Northwind's customers, that don't work in sales,
are explicitly
identified as "Manager" in their job title? Show the
individual
count for all of the various "Manager" titles.
Use a subquery in your FROM clause to filter the data on the
first condition.
*/
#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
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