Views - Display Products by Category

CREATE VIEW products_by_category AS
SELECT category, name, stock_qty
FROM products;