What does the IN operator do in a WHERE clause?

Question

SQL Data Analyst — Easy

What does the IN operator do in a WHERE clause?

Accepted Answer

The IN operator in a WHERE clause tests if a value matches any value in a specified list. This means that the query will return rows where the column value is found in the list provided after the IN keyword.