Can someone please help me with my SQL practice? CATALOG SKU 2013INVENTORYORDER_ITEMCatalod- SKU - SKU_Description- QuantityOnH- QuantityOnO-CatalogP- DateOnWeb-1/1/2013Warehous SKU - SKU_Description100100 Std. Souba Tank, Yellow100200 Std. Souba Tank, Magenta101100 Dive Mask, Small Clear101200 Dive Mask, Med ClearOrderNumt - SKUQuantity- ExtendedP -DepartmentWater Sports100500 Std. Souba Tank, Light Green Water Sports20130003 100600 Std. Scuba Tank, Dark Green Water SportsWater SportsWater SportsCampingCampingClimbingClimbing- Price20130001 100100 Std. Scuba Tank, Yellow231002503000100200130030020130002NULL2013ורו?100200302000101100450200NULL7/1/2013100500300010110025010020130004101100 Dive Mask, Small Clear241/1/201310010050020001012005010020130005 101200 Dive Mask, Med Clear241/1/2013100201000 Half-dome Tent210030001012001505020100020200020130006201000 Half-dome Tent451/1/2013100202000 Half-dome Tent Vestibule1025010001300300100 301000 Light Fly Climbing Harness302000 Locking Carabiner, Oval100100 Std. Souba Tank, Yellow100200 Std. Souba Tank, Magenta20130007 202000 Half-dome Tent Vestibule471/1/2013300250100011301301/1/20131/1/201320130008301000 Light Fly Climbing Harness20130009 302000 Locking Carabiner, Oval7610010007820010050RETAIL_ORDEROrderNumt- StoreNumber- Storezip- OrderMonth98110 DecemberOrderYear -OrderTo-20142007575CATALOG SKU 2014200101100 Dive Mask, Small Clear500100010445Catalod- SKU - SKU_Description- DepartmentWater SportsCatalogP- DateOnWeb-1/1/2014200101200 Dive Mask, Med Clear505002000202335 December201431020140001100100 Std. Scuba Tank, Yellow23200201000 Half-dome Tent1025030001098110 January201548020140002100300 Std. Scuba Tank, Light Blue20140003 100400 Std. Scuba Tank, Dark Blue101100 Dive Mask, Small ClearWater Sports231/1/2014200202000 Half-dome Tent Vestibule1250Water SportsWater SportsNULL8/1/2014200 301000 Light Fly Climbing Harness302000 Locking Carabiner, Oval100100 Std. Scuba Tank, Yellow100200 Std. Souba Tank, Magenta250250SKU_DATA20140004261/1/20142001250SKU- SKU DescriptionDepartmentBuyerWater SportsCamping100100 Std. Scuba Tank, Yellow100200 Std. Souba Tank, MagentaWater SportsWater SportsWater SportsWater SportsCаmpingСampingClimbingClimbing20140005 101200 Dive Mask, Med Clear261/1/2014300100Pete HansenPete HansenNancy MeyersNancy MeyersCindy LoCindy LoJerry Martin20140006201000 Half-dome Tent461/1/201430010010020140007 202000 Half-dome Tent VestibuleCamping461/1/2014300101100 Dive Mask, Small Clear101200 Dive Mask, Med Clear300200101100 Dive Mask, Small Clear20140008301000 Light Fly Climbing HarnessClimbingClimbing771/1/2014300475101200 Dive Mask, Med Clear201000 Half-dome Tent20140009 302000 Locking Carabiner, Oval791/1/2014,300201000 Half-dome Tent250300202000 Half-dome Tent Vestibule100202000 Half-dome Tent VestibuleCATALOG SKU 2015300 301000 Light Fly Climbing Harness302000 Locking Carabiner, Oval100100 Std. Scuba Tank, Yellow100200 Std. Scuba Tank, Magenta250Catalor- SKU - SKU_Description301000 Light Fly Climbing Harness302000 Locking Carabiner, Oval- DepartmentWater SportsWater SportsWater SportsWater SportsCatalogP- DateOnWeb:-300500500Jerry Martin20150001100100 Std. Scuba Tank, Yellow231/1/2015400200100200 Std. Souba Tank, MagentaWAREHOUSEWarehouseSta Manager20150002231/1/2015400250Varehouse- WarehouseCity100 Atlanta200 Chicago300 BangorSquareFee12500020150003101100 Dive Mask, Small Clear271/1/2015400101100 Dive Mask, Small Clear45020150004101200 Dive Mask, Med Clear271/1/2015400101200 Dive Mask, Med Clear250250GADave Jones201000 Half-dome TentCampingCamping20150007 203000 Half-dome Tent Vestibule - Wic CampingClimbing451/1/2015400201000 Half-dome Tent250ILLucille Smith10000020150006 202000 Half-dome Tent Vestibule451/1/2015400202000 Half-dome Tent Vestibule200MEBart Evans150000400 301000 Light Fly Climbing HarnessDale RogersGrace JeffersonNULL4/1/2015250400 SeattleWA13000020150008301000 Light Fly Climbing Harness500 San Francisco200000761/1/2015400302000 Locking Carabiner, Oval1000CA 1. What are all the months that retail orders were made but we only want the first 3 letters of each month.2. What are the warehouse cities where the size is greater than 130,000 square feet. In your output ensure the resultsare all in uppercase and please rename the warehouse cities to "CapitalCity".3. Return the number of rows in the 2013 catalog that have page numbers in them.4. What is the total of extended prices from our orders?5. Return the average of the Extended Prices from our order items if the Price is over 100.6. What are the max prices and minimum prices from our orders? Rename the output as MaxPrice and MinPrice.7. We need to get a table of the warehouse IDs and their respective cities and states. Please provide the cities andstates in the following format: (City), (State) such as "Atlanta, GA". Have the output labeled Location and be sure theresults are in order based on the warehouse ID.8. Return a concatenated string that looks like this form: "We have 200 of the Std. Scuba Tank, Magenta in Warehouse100." From our inventory.The goal here is to have output that returns a row for each row in the table that creates sentences in the format of:"We have (quantity on hand) of the (sku description) in Warehouse (warehouse id)"So the first few lines will be like:"We have 250 of the Std. Scuba Tank, Yellow in Warehouse 100""We have 200 of the Std. Scuba Tank, Magenta in Warehouse 100""We have O of the Dive Mask, Small Clear in Warehouse 100"9. Return only the current year by using a SQL query.10. Return what the date would look like one month from now using a SQL query.

Question

Can someone please help me with my SQL practice? CATALOG SKU 2013INVENTORYORDER_ITEMCatalod- SKU - SKU_Description- QuantityOnH- QuantityOnO-CatalogP- DateOnWeb-1/1/2013Warehous SKU - SKU_Description100100 Std. Souba Tank, Yellow100200 Std. Souba Tank, Magenta101100 Dive Mask, Small Clear101200 Dive Mask, Med ClearOrderNumt - SKUQuantity- ExtendedP -DepartmentWater Sports100500 Std. Souba Tank, Light Green Water Sports20130003 100600 Std. Scuba Tank, Dark Green Water SportsWater SportsWater SportsCampingCampingClimbingClimbing- Price20130001 100100 Std. Scuba Tank, Yellow231002503000100200130030020130002NULL2013ורו?100200302000101100450200NULL7/1/2013100500300010110025010020130004101100 Dive Mask, Small Clear241/1/201310010050020001012005010020130005 101200 Dive Mask, Med Clear241/1/2013100201000 Half-dome Tent210030001012001505020100020200020130006201000 Half-dome Tent451/1/2013100202000 Half-dome Tent Vestibule1025010001300300100 301000 Light Fly Climbing Harness302000 Locking Carabiner, Oval100100 Std. Souba Tank, Yellow100200 Std. Souba Tank, Magenta20130007 202000 Half-dome Tent Vestibule471/1/2013300250100011301301/1/20131/1/201320130008301000 Light Fly Climbing Harness20130009 302000 Locking Carabiner, Oval7610010007820010050RETAIL_ORDEROrderNumt- StoreNumber- Storezip- OrderMonth98110 DecemberOrderYear -OrderTo-20142007575CATALOG SKU 2014200101100 Dive Mask, Small Clear500100010445Catalod- SKU - SKU_Description- DepartmentWater SportsCatalogP- DateOnWeb-1/1/2014200101200 Dive Mask, Med Clear505002000202335 December201431020140001100100 Std. Scuba Tank, Yellow23200201000 Half-dome Tent1025030001098110 January201548020140002100300 Std. Scuba Tank, Light Blue20140003 100400 Std. Scuba Tank, Dark Blue101100 Dive Mask, Small ClearWater Sports231/1/2014200202000 Half-dome Tent Vestibule1250Water SportsWater SportsNULL8/1/2014200 301000 Light Fly Climbing Harness302000 Locking Carabiner, Oval100100 Std. Scuba Tank, Yellow100200 Std. Souba Tank, Magenta250250SKU_DATA20140004261/1/20142001250SKU- SKU DescriptionDepartmentBuyerWater SportsCamping100100 Std. Scuba Tank, Yellow100200 Std. Souba Tank, MagentaWater SportsWater SportsWater SportsWater SportsCаmpingСampingClimbingClimbing20140005 101200 Dive Mask, Med Clear261/1/2014300100Pete HansenPete HansenNancy MeyersNancy MeyersCindy LoCindy LoJerry Martin20140006201000 Half-dome Tent461/1/201430010010020140007 202000 Half-dome Tent VestibuleCamping461/1/2014300101100 Dive Mask, Small Clear101200 Dive Mask, Med Clear300200101100 Dive Mask, Small Clear20140008301000 Light Fly Climbing HarnessClimbingClimbing771/1/2014300475101200 Dive Mask, Med Clear201000 Half-dome Tent20140009 302000 Locking Carabiner, Oval791/1/2014,300201000 Half-dome Tent250300202000 Half-dome Tent Vestibule100202000 Half-dome Tent VestibuleCATALOG SKU 2015300 301000 Light Fly Climbing Harness302000 Locking Carabiner, Oval100100 Std. Scuba Tank, Yellow100200 Std. Scuba Tank, Magenta250Catalor- SKU - SKU_Description301000 Light Fly Climbing Harness302000 Locking Carabiner, Oval- DepartmentWater SportsWater SportsWater SportsWater SportsCatalogP- DateOnWeb:-300500500Jerry Martin20150001100100 Std. Scuba Tank, Yellow231/1/2015400200100200 Std. Souba Tank, MagentaWAREHOUSEWarehouseSta Manager20150002231/1/2015400250Varehouse- WarehouseCity100 Atlanta200 Chicago300 BangorSquareFee12500020150003101100 Dive Mask, Small Clear271/1/2015400101100 Dive Mask, Small Clear45020150004101200 Dive Mask, Med Clear271/1/2015400101200 Dive Mask, Med Clear250250GADave Jones201000 Half-dome TentCampingCamping20150007 203000 Half-dome Tent Vestibule - Wic CampingClimbing451/1/2015400201000 Half-dome Tent250ILLucille Smith10000020150006 202000 Half-dome Tent Vestibule451/1/2015400202000 Half-dome Tent Vestibule200MEBart Evans150000400 301000 Light Fly Climbing HarnessDale RogersGrace JeffersonNULL4/1/2015250400 SeattleWA13000020150008301000 Light Fly Climbing Harness500 San Francisco200000761/1/2015400302000 Locking Carabiner, Oval1000CA 1. What are all the months that retail orders were made but we only want the first 3 letters of each month.2. What are the warehouse cities where the size is greater than 130,000 square feet. In your output ensure the resultsare all in uppercase and please rename the warehouse cities to &#34;CapitalCity&#34;.3. Return the number of rows in the 2013 catalog that have page numbers in them.4. What is the total of extended prices from our orders?5. Return the average of the Extended Prices from our order items if the Price is over 100.6. What are the max prices and minimum prices from our orders? Rename the output as MaxPrice and MinPrice.7. We need to get a table of the warehouse IDs and their respective cities and states. Please provide the cities andstates in the following format: (City), (State) such as &#34;Atlanta, GA&#34;. Have the output labeled Location and be sure theresults are in order based on the warehouse ID.8. Return a concatenated string that looks like this form: &#34;We have 200 of the Std. Scuba Tank, Magenta in Warehouse100.&#34; From our inventory.The goal here is to have output that returns a row for each row in the table that creates sentences in the format of:&#34;We have (quantity on hand) of the (sku description) in Warehouse (warehouse id)&#34;So the first few lines will be like:&#34;We have 250 of the Std. Scuba Tank, Yellow in Warehouse 100&#34;&#34;We have 200 of the Std. Scuba Tank, Magenta in Warehouse 100&#34;&#34;We have O of the Dive Mask, Small Clear in Warehouse 100&#34;9. Return only the current year by using a SQL query.10. Return what the date would look like one month from now using a SQL query.

Accepted Answer

1)Displaying first 3 letters of months in retail order
Select SUBSTRING(OrderMonth,1,3) from…