Your team member is trying to set up a databricks video

Full Certification Question

Your team member is trying to set up a delta pipeline and build a second gold table to the same pipeline with aggregated metrics based on an existing Delta Live table called sales_orders_cleaned but he is facing a problem in starting the pipeline, the pipeline is failing to state it cannot find the table sales_orders_cleaned, you are asked to identify and fix the problem. CREATE LIVE TABLE sales_order_in_chicago AS SELECT order_date , city , sum ( price ) as sales , FROM sales_orders_cleaned WHERE city = 'Chicago' ) GROUP BY order_date , city