Using WHERE with numbers

Filtering with WHERE allows you to analyze your data better. You may have a dataset that includes a range of different movies, and you need to do a case study on the most notable films with the biggest budgets. In this case, you'll want to filter your data to a specific budget range.

Now it's your turn to use the WHERE clause to filter numeric values!

Instructions $\frac{1}{3}$

Select the film$\_$id and imdb$\_$score from the reviews table and filter on scores higher than $7\mathrm{.}0.$

$.$ Take Hint $(-10$ XP$)$

Select the film$\_$id and facebook$\_$likes of the first ten records with less than $1000$ likes from the reviews table.

Count how many records have a num$\_$votes of at least $100,000$; use the alias films$\_$over$\_100$K$\_$votes.