Need help with this:
Write an SQL statement to display data for all of the columns.
Write an SQL statement to display data for SKU_Description and SKU.
Write an SQL statement to Create A View to display data for unique WarehouseIDs.
Write an SQL statement to display all data on products having a QuantityOnHand greater than 0.
Write an SQL statement to display the data for SKU, SKU_Description, and WarehouseID for product having QuantityOnHand equal to 0. Sort the results in ascending order by WarehouseID.
Write an SQL statement to display the data for SKU, SKU_Description, and WarehouseID for products having QuantityOnHand greater than 0. Sort the results in descending order by WarehouseID and ascending order by SKU.
Write an SQL statement to Create A View to display the data for SKU, SKU_Description, WarehouseID, and QuantityOnHand for all products having a QuantityOnHand greater than 1 and less than 10. Provide a screenshot of the result as well.
Write an SQL statement to show data for SKU and SKU_Description for all products having an SKU description starting with ‘Half-dome'.
Write an SQL statement to display the data for WarehouseID and the sum of QuantityOnHand, grouped by WarehouseID. Name the sum ‘TotalItemsOnHand'.
Write an SQL statement to display the data for WarehouseID and the sum of QuantityOnHand grouped by WarehouseID. Omit all SKU items that have 3 or more items on hand from the sum, and name the sum ‘TotalItemsOnHandLT3'. Display the results in descending order of ‘TotalItemsOnHandLT3'.