Question: Cape Codd Database Table Structure: (Tables & Fields) Catalog_SKU_2016 Catalog_SKU_2017 CatalogID (PK, int, not null) SKU (int, not null) SKU_Description (char(35), not null) Department (char(30),


Cape Codd Database Table Structure: (Tables & Fields) Catalog_SKU_2016 Catalog_SKU_2017 CatalogID (PK, int, not null) SKU (int, not null) SKU_Description (char(35), not null) Department (char(30), not null) CatalogPage (int, null) DateOn Web Site (date, null) CatalogID (PK, int, not null) SKU (int, not null) SKU_Description (char(35), not null) Department (char(30), not null) CatalogPage (int, null) DateOnWebSite (date, null) Catalog_SKU_2018 CatalogID (PK, int, not null) SKU (int, not null) SKU_Description (char(35), not null) Department (char(30), not null) CatalogPage (int, null) DateOnWebSite (date, null) ORDER_ITEM RETAIL_ORDER INVENTORY WarehouseID (PK, FK, int, not null) ? SKU FK, int, not null) SKU_Description (char(35), not null) QuantityOnHand (int, null) QuantityOnOrder (int, null) OrderNumber (PK, FK, int, not null) SKU (PK, FK, int, not null) Quantity (int, not null) Price (money, not null) ExtendedPrice (money, not null) ? OrderNumber (PK, int, not null) StoreNumber (int, null) Store Zip (char(9), null) Order Month (char(12), not null) OrderYear (int, not null) OrderTotal (money, null) SKU_DATA WAREHOUSE ? SKU (PK, int, not null) SKU_Description (char(35), not null) Department (char(30), not null) Buyer (char(35), null) WarehouseID (PK, int, not null) WarehouseCity (char(30), not null) WarehouseState (char(2), not null) Manager (char(35), null) Square Feet (int, null) Pirate Toy Store Tables (Tables & Fields) CUSTOMER INVOICE INVOICE_ITEM CustomerID (PK, int, not null) FirstName (char(25), not null) LastName (char(25), not null) Phone (char(12), not null) Email (char(100), null) InvoiceNumber (PK, int, not null) CustomerNumber (FK, int, not null) SaleDate (datetime, not null) TotalAmount (numeric(8,2), null) InvoiceNumber (PK, FK, int, not null) Item Number (PK, int, not null) Item (char(50), not null) Quantity (int, not null) UnitPrice (numeric(8,2), null) 1 2 3 4 5 6 SKU_Description Warehousels QuantityOnOrder Dive Mask, Small Clear 200 500 Dive Mask, Med Clear 200 500 Half-dome Tent 200 250 Half-dome Tent Vestibule 200 250 Light Fly Climbing Harness 200 250 Std. Scuba Tank, Magenta 200 75 Std. Scuba Tank, Yellow 200 50 Locking Carabiner, Oval 200 0 7 8 10. Show all the inventory available in the Chicago warehouse. Include the SKU, SK Description Quantitxo Arder, and Warehouse city. Use an EXPLICIT INNER JOIN and sort by Quantitwanorder in descending order
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
