The shop asks "what can we sell right now?" many times a day. Save the answer as a view.

1. Create a view named in_stock with the id, name and price of every product whose stock is above 0.
2. Use the view to list the in-stock products that cost less than 10.00: id, name, price.
3. The Kraken Plush (product 1) sells out. Set its stock to 0 in products.
4. Think before you run it: how many rows does in_stock show now?
5. Replace the view so that it also shows stock, as the last column.