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
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 ___ > ___;