- Show the total number of orders for products that have productid between 45 and 55, in order by productid.
- Show the first ten rows for table orderdetails in order by productid.
- Show the number of employees who have more than 8 letters in their last name.
- Show the customerids and number of orders that were shipped after the required date for each customer.
Show the number of orders shipped late (as problem 4) by employee, in descending order by number of late orders.
- Show the supplierids of suppliers where we don’t have their region in the database.
- For order details, show the product id, unit price, quantity, discount and total price for the first ten order details. Be sure the total price has the heading “Total Price.”
- Now let’s look at the possible impact of discounts on sales. Show the total dollar volume of orders by size of discount, in descending order by discount.
