Queries 7.) Group-By: Create a query that shows the CookieName, and total Quantity sold for cookies with a total quantity of more than 10 boxes. Save the query as CookieCount (5) 8.) Group-By: Create a query that shows the CustomerID, FirstName, CookieName and total Quantity for all orders with "Lemonade" cookies in them. Save the query as LemonadeOrders. (5) (Hint: "Lemonade" is a specific name) 9.) Group-By: Create a Query that shows OrderID, CookieName, total Quantity, Price and a new field named "Line Total" that calculates the Quantity*Price for line items. Name it Sales. (5) (Hint: This is similar to query # 14 that used the Date Diff() function, however you do not need a function for this query. Just a simple multiplication.) 10.) Create an Update query that increases the price of all cookies by $1. Name the Query Price Update (5)

Solved: Queries 7.) Group-By: Create a query that shows the CookieName, and to

Home
questions and answers
queries 7 group by create a query that shows the cookiename and total

Question

Queries 7.) Group-By: Create a query that shows the CookieName, and total Quantity sold for cookies with a total quantity of more than 10 boxes. Save the query as CookieCount (5) 8.) Group-By: Create a query that shows the CustomerID, FirstName, CookieName and total Quantity for all orders with "Lemonade" cookies in th