You have a table customer_orders in databricks video
data-analyst video for you have a table customer_orders in Databricks SQL with a column order_info in JSON format. This column includes a nested array items ,
Answer
Full Certification Question
You have a table customer_orders in Databricks SQL with a column order_info in JSON format. This column includes a nested array items , where each element has product_id (string) and quantity (integer). How would you write a SQL query to list each product_id and its corresponding quantity for every order? Syntax used to create the table CustomerOrders: CREATE TABLE customer_orders AS SELECT { "items" : [ { "product_id" : "X100" , "quantity" : 3 }, { "product_id" : "Y200" , "quantity" : 1 } ] } as order_info ;