1. 学习
    2. /
  2. 课程
    3. /
  3. Introduction to NoSQL
Connected

练习

Querying document databases

Using Postgres JSON to query document data is similar to querying relational data with Postgres. In this exercise, you'll practice building a query to retrieve document data from the nested_reviews table, with Postgres JSON. Happy querying!

说明

100 XP
  • Update the query to return the review column from the nested_reviews table.
  • Use the appropriate pandas function to create a DataFrame using the logic stored in the query variable.
  • Output the first record in the DataFrame returned after executing the query.