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 ,

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). Which of the following queries returns a single row with two columns—product_id and quantity—for the product with product_id equal to “X100”? 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 ;