SQL: Using WHERE Clause with NOT LIKE Operator and Escape Character
Sometimes, a column value may not have to be in a given range but rather in a given set of values. The IN statement is used to specify a set of values that a column value must be in.
Click http://www.w3resource.com/sql-exercises/sql-wildcard-special-operator-exercise-16.php link to open resource.