Exercise

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 1/3

undefined XP
  • 1
    • Select the film_id and imdb_score from the reviews table and filter on scores higher than 7.0.
  • 2
    • Select the film_id and facebook_likes of the first ten records with less than 1000 likes from the reviews table.
  • 3
    • Count how many records have a num_votes of at least 100,000; use the alias films_over_100K_votes.