train: select filename, project, count(*) as bug_count from bug b join bug_bug_patch bbp on bbp.bug_id = b.id join bug_patch bp on bp.id = bbp.bug_patch_id join bug_file bf on bp.id = bf.bug_patch_id group by project, filename order by bug_count desc;

https://data.releng.team/train?sql=select%0D%0A++filename%2C%0D%0A++project%2C%0D%0A++count%28*%29+as+bug_count%0D%0Afrom%0D%0A++bug+b%0D%0A++join+bug_bug_patch+bbp+on+bbp.bug_id+%3D+b.id%0D%0A++join+bug_patch+bp+on+bp.id+%3D+bbp.bug_patch_id%0D%0A++join+bug_file+bf+on+bp.id+%3D+bf.bug_patch_id%0D%0Agroup+by%0D%0A++project%2C+filename%0D%0Aorder+by%0D%0A++bug_count+desc%3B