CSharp-Most-Popular-Filenames

SELECT filename, COUNT(*) as count
FROM (
SELECT LAST(SPLIT(sample_path, '/')) as filename
FROM [fh-bigquery:github_extracts.contents_net_cs]
)
GROUP BY filename
HAVING count >1ORDER BY count DESCLIMIT1000