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

Querys sql

Language: Layout:
- ] Show input
Absolute running time: 0.44 sec, cpu time: 0.18 sec, memory peak: 7 Mb, absolute service time: 0,55 sec 
fork mode |  history  | discussion
select tableOne, count()/(select count() from arbol) as probabilidad from arbol where tableOne in(select distinct tableOne from arbol) group by tableOne;
select tableOne, tableTwo, count()/(select count() from arbol) as Probabilidad from arbol where tableOne in(select distinct tableOne from arbol) and tableTwo in(select distinct tableTwo from arbol) group by tableOne, tableOne order by tableOne, tableTwo;