• 使用 CREATE VIEW 或 CREATE OR REPLACE VIEW 创建/更新视图。
• 适用于仪表盘、报告和一致的查询结果。

-- Create a view to get recipes with a preparation time of 30 minutes or less

CREATE VIEW QuickRecipes AS
SELECT recipe_id, recipe_name, ingredients, preparation_time
FROM recipes
WHERE preparation_time <= 30;