Database schema:

CREATE TABLE "Classification" (
	"GeneID" TEXT NOT NULL -- example: ['G234064', 'G234065'],
	"Localization" TEXT NOT NULL -- example: ['cytoplasm', 'cytoskeleton'],
	PRIMARY KEY ("GeneID")
)


CREATE TABLE "Genes" (
	"GeneID" TEXT NOT NULL -- example: ['G234064', 'G234065'],
	"Essential" TEXT NOT NULL -- example: ['Essential', 'Non-Essential'],
	"Class" TEXT NOT NULL -- example: ['GTP/GDP-exchange factors (GEFs)', 'ATPases'],
	"Complex" TEXT -- example: ['?', 'Translation complexes'],
	"Phenotype" TEXT NOT NULL -- example: ['?', 'Mating and sporulation defects'],
	"Motif" TEXT NOT NULL -- example: ['PS00824', 'PS00825'],
	"Chromosome" INTEGER NOT NULL -- example: ['2', '1'],
	"Function" TEXT NOT NULL -- example: ['PROTEIN SYNTHESIS', 'CELLULAR ORGANIZATION (proteins are localized to t'],
	"Localization" TEXT NOT NULL -- example: ['cytoplasm', 'cytoskeleton'],
	CONSTRAINT fk_genes_classification FOREIGN KEY("GeneID") REFERENCES "Classification" ("GeneID")
)


CREATE TABLE "Interactions" (
	"GeneID1" TEXT NOT NULL -- example: ['G234064', 'G234065'],
	"GeneID2" TEXT NOT NULL -- example: ['G234126', 'G235065'],
	"Type" TEXT NOT NULL -- example: ['Genetic', 'Genetic-Physical'],
	"Expression_Corr" REAL NOT NULL -- example: ['0.751584888', '0.914095071'],
	PRIMARY KEY ("GeneID1", "GeneID2"), 
	CONSTRAINT fk_interactions_classification FOREIGN KEY("GeneID1") REFERENCES "Classification" ("GeneID"),
	CONSTRAINT fk_interactions_classification FOREIGN KEY("GeneID2") REFERENCES "Classification" ("GeneID")
)

Question: List all genes whose interaction is with genes located in the nucleus in which it is positively correlated.
Evidence: If the Expression_Corr value is positive then it's positively correlated

SQL:
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'