1. Learn
    2. /
  2. Projects
    3. /
  3. Data-Driven Decision Making in SQL
Connected

Exercise

Categories of movies

Give an overview on the movies available on MovieNow. List the number of movies for different genres and release years.

Instructions 1/2

undefined XP
    1
    2
  • List the number of movies for different genres and the year of release on all aggregation levels by using the CUBE operator.