You are given a database in a MS Access file called DBP-e14-Cape-Codd that contains data collected in an outdoor sports retail store. The retail store hired you as a data analyst to answer questions in order to help them make business decisions that will help them grow. Write the SQL statement for each query and save them in MS Access as Q1, Q2, Please submit the MS Access and MS Word to help speed the grading turnout! in Blackboard. (to help you answer these questions, you shoud practice running the practice SQL queries shown in the videoes). Query Question SQL Statement

1 Show the sku, description, and the buyer name in department name in one cell as sponsor (RTRIM(Buyer)&' in '&RTRIM(Department) as Sponsor)

2 For each department, show the number of items in which catalog page for 2014 was not blank

3 For each department, show the number of items they contain for sku/item that is not 302000 and the total number of items is more than 1

4 Can you show an example of an SQL cross join (Cartesian product) for the retail_order and order_item tables? This is illogical in database work because we only need rows that somehow logically correspond in the two tables.

5 Can you create an implicit SQL inner join for retail_order and order_item tables? Sort by order number and SKU of Order_Item

6 Can you create an explicit SQL inner join for retail_order and order_item tables? Sort by order number and SKU of Order_Item

7 List all records from retail_order and order_item tables for the year 2014. Sort by order number and SKU of Order_Item

8 For every department, show the average order item price

9 Which manager had the largest amount (quantity) of item-orders?

10 For every store (storeNumber), how many departments are there?

11 How much total money (extendedprice) did we make from each buyer? 12 How much total money (extendedprice) was each manager responsible for?

Require assistance with 7 through 12 and #3.

SELECT saemeFROM Table Names Conditional Expression WHERE2 GROUP BYLr Conon Conditional HAVING4 Colume List ORDER BY 6 DATA TALOG SKU 2014 OrderNumber StoreNumber StorezIP OrderMonth OrderYear OrderTotal SKU Description Department SKU SKU Description SKU Description Manager DateOnW