-- Database schema
| Classification : GeneID [ TEXT ] primary_key , Localization [ TEXT ] | Genes : GeneID [ TEXT ] Genes.GeneID = Classification.GeneID , Essential [ TEXT ] , Class [ TEXT ] , Complex [ TEXT ] , Phenotype [ TEXT ] , Motif [ TEXT ] , Chromosome [ INTEGER ] , Function [ TEXT ] , Localization [ TEXT ] | Interactions : GeneID1 [ TEXT ] Interactions.GeneID1 = Classification.GeneID , GeneID2 [ TEXT ] Interactions.GeneID2 = Classification.GeneID , Type [ TEXT ] , Expression_Corr [ REAL ] |
-- -- If a pair of genes is positively correlated, what is the possibility of it being composed of two genes both with over 10 chromosomes?

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;