You are given a database in a MS Access file called 'DBP-e14-Cape-Codd' that contains data collected...

 

Transcribed Image Text:

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. RETAIL ORDER OrderNumber StoreNumber StoreZIP Order Month SKU DATA SKU SKU Description FEESE Department Buver OrderYear OrderTotal Query Question 1 2 3 4 5 6 7 8 9 10 11 12 ORDER ITEM OrderNumber SKU Quantity Price SELECT FROM Extended Price 5 1 WHERE 3 GROUP BY HAVING ORDER BY ; INVENTORY Warehouse D SKU SKU Description QuantityOnHand QuantityOnOrder 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? This is illogical in database work because we only need rows that somehow logically correspond in the two tables. Can you create an implicit SQL inner join for retail order and order_item tables? Sort by order number and SKU of Order_Item Can you create an explicit SQL inner join for retail_order and order_item tables? Sort by order number and SKU of Order Item List all records from retail_order and order_item tables for the year 2014. Sort by order number and SKU of Order Item For every department, show the average order item price Which manager had the largest amount (quantity) of item-orders? For every store (storeNumber), how many departments are there? How much total money (extendedprice) did we make from each buyer? How much total money (extendedprice) was each manager responsible for? WAREHOUSE WarehouseID WarehouseCity WarehouseState Manager SquareFeet SQL Statement CATALOG SKU 2014 CatalogID SKU SKU Description Department CatalogPage DateOnWebSite 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. RETAIL ORDER OrderNumber StoreNumber StoreZIP Order Month SKU DATA SKU SKU Description FEESE Department Buver OrderYear OrderTotal Query Question 1 2 3 4 5 6 7 8 9 10 11 12 ORDER ITEM OrderNumber SKU Quantity Price SELECT FROM Extended Price 5 1 WHERE 3 GROUP BY HAVING ORDER BY ; INVENTORY Warehouse D SKU SKU Description QuantityOnHand QuantityOnOrder 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? This is illogical in database work because we only need rows that somehow logically correspond in the two tables. Can you create an implicit SQL inner join for retail order and order_item tables? Sort by order number and SKU of Order_Item Can you create an explicit SQL inner join for retail_order and order_item tables? Sort by order number and SKU of Order Item List all records from retail_order and order_item tables for the year 2014. Sort by order number and SKU of Order Item For every department, show the average order item price Which manager had the largest amount (quantity) of item-orders? For every store (storeNumber), how many departments are there? How much total money (extendedprice) did we make from each buyer? How much total money (extendedprice) was each manager responsible for? WAREHOUSE WarehouseID WarehouseCity WarehouseState Manager SquareFeet SQL Statement CATALOG SKU 2014 CatalogID SKU SKU Description Department CatalogPage DateOnWebSite

Answer rating: 100% (QA)

8 select sDepartment avgoPrice from ORDERITEM o SKUDATA s wher... View the full answer