CustomerID
CustomerName
ContactName
Address

1
Alfreds Futterkiste
Maria Anders
Obere Str. 57

2
Ana Trujillo Emparedados y helados
Ana Trujillo
Avda. de la Constitución…

3
Antonio Moreno Taquería
Antonio Moreno
Mataderos 2312

The IN operator is used in the WHERE clause to define a list of values or a sub query. In the parenthesis, specify a sub-query or a list of values, such as IN (value1, value2,…) or IN (Select query).