please answer all parts thank u.

Use the cape_codd database for questions 1-5. 1. Write a SQL statement to display the SKU, SKU_Description, and QuantityOnHand columns from the inventory table with WarehouseID equal to 100. 2. Is there anything out of stock at the warehouse with WarehouseID equal to 100? If yes, what? Use a comment to answer this question 3. Write a SQL statement to display the SKU, SKU_Description, and QuantityOnOrder columns from the inventory table with QuantityOnHand equal to 0. 4. Write a SQL statement to display the WarehouseCity and WarehouseState columns from the warehouse table with WarehouseID equal to 500? 5. Write a SQL statement to display the Warehousel column from the inventory table that have a QuantityOn Hand equal to 0. Remove duplicate rows, QuantityOnHand 250 200 0 SKU SKU_Description 100100 Std. Scuba Tank, Yellow 100200 Std. Scuba Tank, Magenta 101100 Dive Mask, Small Clear 101200 Dive Mask, Med Clear 201000 Half-dome Tent 202000 Half-dome Tent vestibule 301000 Light Fly Climbing Harness 302000 Locking Carabiner, Oval 100 2 10 300 1000 3. QuantityOnOrder 500 500 250 SKU SKU_Description 101100 Dive Mask, Small Clear 101100 Dive Mask, Small Clear 201000 Half-dome Tent 202000 Half-dome Tent Vestibule 301000 Light Fly Climbing Harness 30 1000 Light Fly Climbing Harness 302000 Locking Carabiner, Oval 200 250 250 1000 4. WarehouseState WarehouseCity San Francisco CA 5. WarehouseID 100 200 300 400 6. NULL LastName Johnson Wilkens Smith Gray Smathers Janes Frederickson Warnina Wu Twilight FirstName EmailAddress Lvnda Chris Chris. Wilkens (somewhere.com David David. Smith somewhere.com Donald Donald. Grav@somewhere.com Fred.Smathers@somewhere.com Jeffrey Jeffrev.Janes@somewhere.com Marv Beth MarvBeth.Frederickson@somewhere.com Selma Selma. Warning@somewhere.com Susan Susan. Wu@somewhere.com Tiffany Tiffany. Twilight@somewhere.com Fred 7. WorkID 500 500 511 521 522 523 524 537 548 551 Acquisition Price 40000.00 30000.00 250.00 125.00 250.00 250.00 200.00 1500.00 15000.00 125.00