WHERE statement is used to define a filter expression?

Yes. For example, using a database containing a table clients:

SELECT clients.Name

FROM clients

WHERE clients.city='New York'

would show ONLY the clients from New York