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.

This exercise is part of the course

Database Design

View Course

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

-- Create a view for reviews with a score above 9
___ ___ high_scores ___
SELECT * FROM ___
WHERE ___ > ___;