Hector G Paredes Lopez - 3NM70 - Tarea Queries

select materia, count(*)/(select count(*) from financieras) as probabilidad from financieras where materia in(select distinct materia from financieras) group by materia;
select materia, industria, count(*)/(select count(*) from financieras) as Probabilidad from financieras where materia in(select distinct materia from financieras) and industria in(select distinct industria from financieras) group by industria, materia order by materia, industria;