1. 学习
  2. /
  3. 项目
  4. /
  5. Data-Driven Decision Making in SQL

Connected

练习

Average movie ratings

For each movie the average rating, the number of ratings and the number of views has to be reported. Generate a table with meaningful column names.

说明 1 / 共 4 个

undefined XP
    1
    2
    3
    4
  • Group the data in the table renting by movie_id and report the ID and the average rating.