1 parent 071421b commit e7734f3Copy full SHA for e7734f3
1 file changed
WHERE.sql
@@ -322,6 +322,6 @@ SELECT Gene_ID, Gene_Annotation, Gene_length, RPKM FROM rnaseq WHERE RPKM NOT B
322
-- SELECT columns Gene_ID, Gene_Annotation, Gene_length, RPKM from the table rnaseq WHERE RPKM NOT BETWEEN 1 AND 2.5; Tier #9 1 - 2.5
323
SELECT Gene_ID, Gene_Annotation, Gene_length, RPKM FROM rnaseq WHERE RPKM NOT BETWEEN 1 AND 2.5;
324
-- SELECT columns Gene_ID, Gene_Annotation, Gene_length, RPKM from the table rnaseq WHERE RPKM BETWEEN 0 AND 1; Tier #10 0 - 1
325
-SELECT Gene_ID, Gene_Annotation, Gene_length, RPKM FROM rnaseq WHERE RPKM BETWEEN 0 AND 1;
+SELECT Gene_ID, Gene_Annotation, Gene_length, RPKM FROM rnaseq WHERE RPKM NOT BETWEEN 0 AND 1;
326
-- SELECT columns Gene_ID, Gene_Annotation, Gene_length, RPKM from the table rnaseq WHERE RPKM=0; Tier #11 - 0
327
SELECT Gene_ID, Gene_Annotation, Gene_length, RPKM FROM rnaseq WHERE RPKM=0;
0 commit comments