Run Code  | API  | Code Wall  | Misc  | Feedback  | Login  | Theme  | Privacy  | Patreon 

Superquery's

Language: Layout:
- ] Show input
Absolute running time: 0.26 sec, cpu time: 0.16 sec, memory peak: 7 Mb, absolute service time: 0,44 sec  
edit mode |  history  | discussion
select materia, count(*)/(select count(*) from financieras) as probabilidad from financieras where materia in(select distinct materia from financieras) group by materia;

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

    
                
λ
.NET NoSQL database for rapid development