You are given a database in a MS Access file 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.

Table Name FROM 1 Conditional Expression WHERE2 GROUP BYCondstional HAVING 4 Colum Lise ORDER BY 6 KU DATA ATALOG SK WarehouseID SKU Quantity Price SKU Descriotion Department Buver SKU SKU Description StorezIP QuantityOnHand QuantityOnOrder Manager OrderYear OrderTotal Quer y Question Listall records from retail_order and order_itemtables for the year 2014. Sort SQL Statement 7 by order number and SKU of Order_Item 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? 12How much total money (extendedprice) was each manager responsible for