The WHERE clause is used to set conditions for the query. For instance, a query could be set to only return rows with a certain value or a range of values in a certain column. The following query will return the number of repositories that have code files written in the PHP language:

#legacySQL
SELECT COUNT(1) 
FROM [bigquery-public-data:github_repos.languages] 
WHERE language.name = 'PHP'