Write SQL query to solve given problem: What is the cost for the product "847"?. Keep the solution inside sql tag ```sql [SQL-Query] ```
SELECT StandardCost FROM ProductCostHistory WHERE ProductID = 847