It's important to remember that BETWEEN is inclusive, meaning the beginning and end values are included in the results!

WHERE IN

As you've seen, WHERE is very useful for filtering results. However, if you want to filter based on many conditions, WHERE can get unwieldy. For example: