SQL

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?

SELECT Name) Table Names Required foreveny FROM , 2 WHERE2 Conditional Expression GROUP BY Co Lat Conn Conditiona HAVING4 Colume List ORDER BY6 ATALOG SK CataloalD SKU SKU Description Department CataloaPace DateOnWebSite WarehouseID OrderNumber OrderNumber Sinas StoreZIP OrderMonth OrderYear OrderTotal SKU Description Department Buyer SKU Ouantity SKU Description te Manager