SQL practice: JSON and JSONB: Documents Inside Rows

Turn each Adhesive product into a JSON object with keys name and price (from unit_price), in a column named product. Order by product_id.

Show every product as a single JSON document of the whole row, in a column named doc, alongside its product_id. Order by product_id.

For every branch, build a JSON array of its employees’ names sorted alphabetically, in a column named team. Show branch_name too, ordered by branch_name.

Using to_jsonb over products, list the name of every product whose unit_price is above 3000, read out of the JSON rather than the column. Name the output column name and order by it.

Count how many products are in the Adhesive category, using the JSON containment operator @> rather than a WHERE on the column. Name the count adhesives.

Take the document {"city": "Delhi", "region": "North", "open": true} and return one row per key, with columns key and value. Order by key.

Build one JSON document per order containing the order_id and an array of the product names it contains, in a column named doc. Only include order 1, 2 and 3, ordered by order_id.

Which statement about json and jsonb is true?