The OMIT RECORD IF option is used for filtering out values based on the aggregation of the repeated field. The following query returns the names of the repositories that have more than 100 programming languages used in that repository:
#legacySQL
SELECT
repo_name
FROM [bigquery-public-data:github_repos.languages]
OMIT RECORD IF COUNT(language.name) < 100