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

Superquerys Segura Sanchez

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

select empresa, recursos, count()/(select count() from capital) as Probabilidad from capital where empresa in(select distinct empresa from capital) and recursos in(select distinct recursos from capital) group by recursos, empresa order by empresa, recursos;

    
                
λ
.NET NoSQL database for rapid development