I cant figure out how to create a query in access with this information.

A. The supply chain department would like a list of the currently sold products whose quantity on hand has dropped below the reorder point. Design a query that displays the product name, supplier and the supplier's phone number, the quantity on hand and the reorder level for all currently sold products where the in-stock quantity has dropped below the reorder level. Name A. The supply chain department would like a list of the currently sold products whose quantity on hand has dropped below the reorder point. Design a query that displays the product name, supplier and the supplier's phone number, the quantity on hand and the reorder level for all currently sold products where the in-stock quantity has dropped below the reorder level. Name