1. Learn
  2. /
  3. Courses
  4. /
  5. Database Design

Exercise

Creating and querying a view

Have you ever found yourself running the same query over and over again? Maybe, you used to keep a text copy of the query in your desktop notes app, but that was all before you knew about views!

In these Pitchfork reviews, we're particularly interested in high-scoring reviews and if there's a common thread between the works that get high scores. In this exercise, you'll make a view to help with this analysis so that we don't have to type out the same query often to get these high-scoring reviews.

Instructions 1/2

undefined XP
    1
    2
  • Create a view called high_scores that holds reviews with scores above a 9.