*In SQL* Customers (CustomerID, CustomerName, ContactName, Address, City, PostalCode, Country) Categories (CategoryID,

[answerhappygod]

*In SQL*
Customers (CustomerID, CustomerName,
ContactName, Address, City, PostalCode, Country)
Categories (CategoryID, CategoryName,
Description)
Employees (EmployeeID,LastName,
FirstName, BirthDate, Photo, Notes)
Orderdetails (OrderDetailID, OrderID,ProductID,
Quantity)
Orders (OrderID, CustomerID, EmployeeID,
OrderDate, ShipperID)
Products (ProductID, ProductName, SupplierID,
CategoryID, Unit, Price)
Shippers (ShipperID, ShipperName, Phone)
Suppliers (SupplierID, SupplierName,
ContactName, Address, City, PostalCode, Country, Phone)
Q1. Show the orderId, the Employee Last Name, and Shipper Name
sorted by the Employee Last name
Q2. Show productName, CategoryName, and count the number of
products for each category and only show those counts that are
>= 5. Call the calculated field:
NumberofProductsPerCategory
Q3. Show the orderId, the Employee Last Name, the product Name,
and show only these number of orders between 5 and 10 done by each
Employees (NumberOfOrdersPerEmployee).
Q4. Show ProductName, Quantity, Price, (Quantity * Price ) as
subtotal, (Quantity * price * .0825) as taxAmount, and total as
(Quantity * price + (Quantity * price * .0825)). Only Select the
productName if the quantity >= 10.