I don't know how to do this sql.Can someone help me please? OingCATALOG SKU 2013INVENTORYORDERITEMCatalo SKU- SKU DescriptionDepartment - CatalogP - DateOnWeb -Warehous SKU - SKU Desoription-QuantityOnH-QuantityOn0250Quantity100200101100101100PriceExtendedP-300OrderNumt- SKU-20130001100100 Sed. Scuba Tark, Yellow Water Sports100500 Sed. Scuba Tark, Light Geen Water Sports100600 Sed. Souba Tank, Dark Green Water Sports101100 Dive Mask, Small Clear101200 Dive Mask, Med Clear201000 Hall-dome Tent23112013100 100100 Std Souba Tank, Yellov30003002013000220130003NULL7112013712013100 100200 Sid Scuba Tank, Magenta100 101100 Dive Mask, Smal Clear10010020030500200030005050200100NULL2.20130004Water Sports24112013101200 Dive Mask, Med Clear10050010020003000100010120010120050100V12013V201320130005201000 Hal-dome Tert2Water SportsCampingCampingClimbingCimbing24150300503002013000620130007 202000 Hal-dome Tenx Vestibule20100020200045100 202000 Hal-dome Tert Vestibule10250147V1201312013130100 301000 Lighe Fly Climbing Harness100 302000 Looking Carabiner, Oval200 100100 Std Souba Tank, Yellw200 100200 Std Souba Tank, Magenta2003001000250100013020130008 301000 Light Fly Climbing Harness20130009 302000 Locking Carabiner, Oval7678V1201310050RETAIL_ORDEROrderNumt- StoreNumber1000- Storežip10- OrderMonth98110 December- OrderYear OrderTo20147575500CATALOG SKU 2014-DepartmentWater Sports101100 Dive Mask, Small Clear445CatalogP- DateOnWeb-Catalo SKU - SKU Desoription2014000120140002 100300 Sed. Scuba Tank, Light Blue Water Sports20140003 100400 Sed. Souba Tank, Dark Blue Water Sports201400042014000520140006 201000 Hal-dome Tert20140007 202000 Hall-dome Tenk Vestibule20140008 301000 Light Fly ClimbingHarness20140009 302000 Locking Carabiner, Oval200 101200 Dive Mask, Med Clear200200 202000 Hal-dome Tent Vestbule505002000202335 December2014310100100 Sed. Scuba Tank, Yellov30002323112014201000 Hal-dome Tent1012501098110 January2015480V2014250SKU DATA- DepartmentWater SportsWater SportsWater SportsWater SportsCampingСampingClimbingClmbing200 301000 Light Fly Climbing Harness200 302000 Looking Carabiner, Oval100100 Sid Souba Tank, Yellov100200 Sid. Souba Tank, Magenta101100 Dive Mask, Small ClearNULL8/1/20142501250250101100 Dive Mask, Small ClearWater SportsWater SportsV12014- SKU Desoription100100 Std. Souba Tank, YelowBuyerPete HansenPete Hansen26SKU101200 Dive Mask, Med Clear26V12014300100100200 Std. Souba Tank, Magenta101100 Dive Mask, Small ClearCampingCampingClmbingClimbing4646112014300300100300100200Nancy MeyersNancy MeyersCindy LoCindy LoJerry MartinJerny MartinV201477112014300101200 Dive Mask, Med Clear300 201000 Hal-dome Tent300 202000 Half-dome Tent Vestibule475101200 Dive Mask, Med Clear201000 Hal-dome Tent202000 Half-dome Tent Vestibule79VW2014,250100CATALOG SKU 2015300301000 Light Fly Climbing Harness300 302000 Locking Carabiner, Oval100100 Sid Souba Tank, Yellov100200 Sid. Souba Tank, Magenta101100 Dive Mask, Small Clear250301000 Light Fly Climbing Harness302000 Locking Carabiner, OvalCatalo SKU - SKU Description201500012015000220150003- Department- CatalogP- DateOnWeb-Water SportsWater SportsWater Sports500500100100 Sed. Souba Tark, Yellov100200 Sed. Scuba Tank, Magenta101100 Dive Mask, Small Clear23V2015400200232711201512015400400250450250WAREHOUSEWarehouseSta- ManagerGAWarehous WarehouseCity2015000420150005 201000 Hall-dome Tent20150006 202000 Half-dome Tenk Vestibule101200 Dve Mask, Med Clear201000 Hal-dome Tent400 202000 Half-dome Tent VestibuleSquareFee125000100000150000101200 Dive Mask, Med ClearWater Sports27112015400250100 AtlantaDave JonesCampingCamping20150007 203000 Half-dome Tent Vestibule- Wic CampingClimbing200 Chicago300 Bangor400 SeattleS00 Sao Francisco4545112015W2015400250200ILLucille SmithBart EvansDale RogersGrace JelfersonMENULL4/1/2015400301000 Light Fly Climbing Harness400 302000 Locking Carabiner, Oval250WA13000020150008301000 Light Flu Climbing Harness76w20151000CA200000 We need to know total costs for our quantity on order. We will do this by taking the quantity on order andmultiplying it by the price of each individual item. Please gather the SKU, warehouse ID, quantity that we have onorder, price and then include a column for the total that the quantity cost and name this column Total Cost. Havethe output order results by the warehouse ID. Be sure that the SKUS are unique within each Warehouse. I am lookingfor a calculated field here. The "total that the quantity cost" will be a calculated field. Remember, a calculated field lookslike a little math equation inside the select statement. An example of a calculated field in a select might be SELECTQuantityOnOrder * QuantityOnHand AS Total

We need to know total costs for our quantity on order. We will do this by taking the quantity on order and multiplying it by the price of each individual item. Please gather the SKU, warehouse ID, quantity that we have on order, price and then include a column for the total that the quantity cost and name this column Total Cost. Have the output order results by the warehouse ID. Be sure that the SKUS are unique within each Warehouse. I am looking for a calculated field here. The "total that the quantity cost" will be a calculated field. Remember, a calculated field looks like a little math equation inside the select statement. An example of a calculated field in a select might be SELECT QuantityOnOrder * QuantityOnHand AS Total