• 使用 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;