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.
Diese Übung ist Teil des Kurses
Cleaning Data in SQL Server Databases
Interaktive Übung
Versuche dich an dieser Übung, indem du diesen Beispielcode vervollständigst.
SELECT * FROM series
-- Exclude the out of range values
WHERE ___ ___ 0 ___ 5000