Excluding out of range values
In the previous exercise, you detected the rows with a number of ratings that were out of range.
The logical operator BETWEEN, and the comparison operators >, <, and =, can help you to exclude the rows with out of range values.
This time, you want to get all the rows from the series table, ranging from 0 to 5000.
This exercise is part of the course
Cleaning Data in SQL Server Databases
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
SELECT * FROM series
-- Exclude the out of range values
WHERE ___ ___ 0 ___ 5000