-- 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 ] |
-- -- List all genes whose interaction is with genes located in the nucleus in which it is positively correlated.

SELECT T1.GeneID FROM Genes AS T1 INNER JOIN Interactions AS T2 ON T1.GeneID = T2.GeneID1 WHERE T2.Expression_Corr > 0 AND T1.Localization = 'nucleus';