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 ATALOG SK KU DATA SKU Descriotion Buver WarehouseID SKU SKU Description Quantity Price StorezIP QuantityOnHand QuantityOnOrder Manager OrderYear OrderTotal uery Question SQL Statement Show the sku, description, and the buyer name "in" department name in one cell as sponsor (RTRIM(Buyer)& in '&RTRIM(Department) as Sponsor) For each department, show the number of items in which catalog page for 2014 was not blank 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 Can you show an example of an SQL cross join (Cartesian product) for the retail_order and order item tables? 4 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_ltem