SQL

select idempresa, count (*)/(select count(*) from empresa) as probabilidad from empresa where idempresa in (select distinct idempresa from empresa) and idindustria in (select distinct idindustria from encadenamiento) group by idindustria, idempresa order by idempresa, idindustria;