Vinod_Malleshappa_LAB2_Exercise_7.sql

SELECT
  LANGUAGE.name AS language_name,
  COUNT(LANGUAGE.name) AS count
FROM
  `bigquery-public-data.github_repos.languages`,
  UNNEST(LANGUAGE) AS
  LANGUAGE
GROUP BY
  LANGUAGE.name
ORDER BY
  count DESC
LIMIT
  1