Sales

$1.$ Create a query to expand the sales and sales items table. It should include the order#$,$customer#$,$ sale$\_$date, truck$\_$vin, cash$\_$receipt#$,$ store#$,$ qty$\_$sold, sale$\_$price, and sale$\_$amt, where sale$\_$amt is the sales items amounts by multiplying the quantity sold times the sale price $($sale$\_$amt $=$ qty$\_$sold$*$sale$\_$price$).$ Remember to restrict transactions to the $1$st quarter. Name this query $$Sales Detail Q$1.$

$2.$ Accumulate sales by store during the quarter. Name the sum variable as Revenue and name this query $$Sales Revenue by Store$.$

Cost of Goods Sold

$1.$ Extend the flower purchase items by multiplying the quantity purchased times the purchase price $($purch$\_$amt$=$ qty$\_$purch$*$ purchase$\_$price$).$ Also include purchase#$,$ purchase$\_$date, check#$,$ store#$,$ inventory#$,$ qty$\_$purch, purchase$\_$price in the result.

Restrict transactions to the $1$st quarter. Name this query $$Purchases Flowers Detail Q$1.$

$2.$ Accumulate flower purchases as cost of goods sold by store during the quarter. Name the sum variable as COGS and name this query $$Purchases $($COGS$)$ by Store$.$