If a pair of genes is positively correlated, what is the possibility of it being composed of two genes both with over 10 chromosomes?
Positively correlated means Expression_Corr > 0; Possibility = count(the pairs of genes with both chromosomes over 20) / count(pairs of genes that are positively correlated)
SELECT CAST(SUM(IIF(T1.Chromosome > 10 AND T3.Chromosome > 10, 1, 0)) AS REAL) * 100 / COUNT(T1.GeneID) FROM Genes AS T1 INNER JOIN Interactions AS T2 ON T1.GeneID = T2.GeneID1 INNER JOIN Genes AS T3 ON T3.GeneID = T2.GeneID2 WHERE T2.Expression_Corr > 0
database name:db_id genes
Classification table Classification Cols: gene id dtype text, Localization dtype text, 
Genes table Genes Cols: gene id dtype text, Essential dtype text, Class dtype text, Complex dtype text, Phenotype dtype text, Motif dtype text, Chromosome dtype integer, Function dtype text, Localization dtype text, 
Interactions table Interactions Cols: gene id 1 dtype text, gene id 2 dtype text, Type dtype text, Expression correlation score dtype real, 
