Question: Please attach images from Microsoft Access with answers for queries Queries: Create a query that will COUNT the orders placed between 6/1/2015 and 6/1/2016 (OrderDate)
Please attach images from Microsoft Access with answers for queries Queries:
Create a query that will COUNT the orders placed between 6/1/2015 and 6/1/2016 (OrderDate) from customers in Brazil (CustomerCountry). Name the query OrderCount. How many orders were placed?
Create a query that shows the AVERAGE freight (from Orders table) for each Country (from Customers table). Name the query AvgFreight. How much more is the average freight paid by customers in Belgium than the average freight paid by customers in Spain?
Create a query that answers the following question: Which products (ProductName) did the customer with CustomerID GROSR order? Name the query CustOrder.
Create a query that will give you the answer to this question: For the product with ProductName Outback Lager what is the SUM of the Quantity ordered? (In other words, the total quantity ordered for that product.) Name the query ProductQuantity.
Which customer (CustomerName) generated the most revenue? Name the query CustRevenue. Revenue=UnitPrice*Quantity.
Use the query from Q5. How much revenue did the customer who generated the most revenue generate?
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
