use access to solve questions
Programming
Q1. How many orders were ordered between 10/3/2005 and 04/3/2006(including these two dates):
Q2. What is the total revenue for the company in 2006? (hint:revenue for each order=unitprice*quantity)
Q3. How many customers are from USA or Canada or Mexico?
Q4. How many countries only have two or less customers?
Q5. What is the total quantity of items that was ordered on OrderID 10555?
Q7. Which customer has generated the least amount of revenue for us?(hint: revenu10. e for each order=[orderunitprice*orderquantity]
Q8. which of the following customers has placed the fewest number of orders?
Q9. Which of the following customers is from Beijing?
Q10. Which of the following customers has an at least 2 unshipped orders?
