The WHERE clause is applied directly after the FROM clause.
[ WHERE expression ]
A Boolean type.
The WHERE clause has the same semantics as described for Transact-SQL. It restricts the objects produced by the query expression by limiting the elements of the source collections to those that pass the condition.
select c from cs as c where e
e must have the type Boolean.
The WHERE clause is applied directly after the FROM clause and before any grouping, ordering, or projection takes place. All element names defined in the FROM clause are visible to the expression of the WHERE clause.