Figure 4 - Products Database - The ERD (Entity Relationship Diagram) Relationships Customers Orders Products Orders Products 1 00 00 Oo og OrderID 9 ProductID Unit Price Quantity oo OO y Customerlo FirstName LastName Address City State Zip Country OrderiD Customer SalesReplD Shipper OrderDate RequiredDate ShippedDate Shipping Cost 9 ProductID ProductName Suppliers ProductUnitPrice Unitsin Stock Units OnOrder ReorderLevel SKU Active Suppliers Supplier CompanyName Contact Name ContactTitle Address City State Zip Shipping Companies 8 ShipperiD Company Name City State Phone SalesReps * Sales ReplD FirstName LastName Title Address City State Zip DateofHire DateInserted Question 13 5 pts Refer to Figure III/IV The operations group has requested report showing, for each product, the difference between the number of units in stock and the reorder level; in particular, negative values of this difference indicate products that need to be reordered. To satisfy their request, write a SQL query that shows the name of each product, the unit price, the number of units in stock, the reorder level, and the difference between the units in stock and reorder level (named "UnitStatus"). Sort the results alphabetically by product name. SELECT ProductName, ProductUnitPrice. UnitsInStock, ReorderLevel. (UnitsInStock-Reorderlevel) AS Unit StatusFROM products ORDER BY Product Name ASC: SELECT ProductName, ProductUnitPrice UnitsInStock, ReorderLevel. (UnitsInStock-ReorderLevel) AS Unit Status FROM productsGROUP BY ProductName DESC: SELECT ProductName, Product UnitPrice, UnitsInStock, ReorderLevel, (UnitsInStock-Reorderlevel) AS Unit StatusFROM products ORDER BY Product Name DESC; SELECT Product Name Product UnitPrice, Units Instock, ReorderLevel, (UnitsInStock-ReorderLevel) AS Products Field Name 8 ProductID ProductName SupplierID ProductUnitPrice UnitsinStock UnitsOnOrder ReorderLevel SKU Active Data Type AutoNumber Short Text Number Currency Number Number Number Short Text Yes/No Orders Field Name * Ordered Customers SalesRepID ShipperID OrderDate RequiredDate ShippedDate Shipping Cost Data Type AutoNumber Number Number Number Date/Time Date/Time Date/Time Number Customers Field Name 8 CustomerID FirstName LastName Address City State Zip Country Data Type AutoNumber Short Text Short Text Short Text Short Text Short Text Short Text Short Text SalesReps Field Name 8 SalesReplD FirstName LastName Title Address City State Zip DateofHire Datelnserted Data Type AutoNumber Short Text Short Text Short Text Short Text Short Text Short Text Short Text Date/Time Date/Time ProductsOrders Field Name 8 OrderID 8 ProductID UnitPrice Quantity Data Type Number Number Number Number