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

Query_Polizona

Language: Layout:
- ] Show input
Absolute running time: 0.32 sec, cpu time: 0.18 sec, memory peak: 7 Mb, absolute service time: 0,43 sec 
edit mode |  history  | discussion
select mercado, industria, count(*)/(select count(*) from balances) as proba from balances where mercado in (select distinct mercado from balances) and industria in (select distinct industria from balances) group by mercado, industria;