Skip to content

Commit b69e606

Browse files
novapythnovapyth
committed
Update WHERE.sql
1 parent 6227116 commit b69e606

1 file changed

Lines changed: 1 addition & 1 deletion

File tree

‎WHERE.sql‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -306,7 +306,7 @@ SELECT Gene_ID, RPKM FROM rnaseq WHERE Gene_length NOT BETWEEN 600 AND 1200;
306306
-- SELECT columns Gene_ID, Gene_Annotation, Gene_length, RPKM from the table rnaseq WHERE RPKM > 1000; Tier #1 >1000
307307
SELECT Gene_ID, Gene_Annotation, Gene_length, RPKM FROM rnaseq WHERE RPKM >1000;
308308
-- SELECT columns Gene_ID, Gene_Annotation, Gene_length, RPKM from the table rnaseq WHERE RPKM BETWEEN 250 AND 1000; Tier#2:250 - 1000
309-
SELECT Gene_ID, Gene_Annotation, Gene_length, RPKM FROM rnaseq WHERE RPKM BETWEEN 250 AND 1000;
309+
SELECT Gene_ID, Gene_Annotation, Gene_length, RPKM FROM rnaseq WHERE RPKM NOT BETWEEN 250 AND 1000;
310310
-- SELECT columns Gene_ID, Gene_Annotation, Gene_length, RPKM from the table rnaseq WHERE RPKM BETWEEN 100 AND 250;Tier#3:100 - 250
311311
SELECT Gene_ID, Gene_Annotation, Gene_length, RPKM FROM rnaseq WHERE RPKM BETWEEN 100 AND 250;
312312
-- SELECT columns Gene_ID, Gene_Annotation, Gene_length, RPKM from the table rnaseq WHERE RPKM BETWEEN 50 AND 100; Tier#4: 50 - 100

0 commit comments

Comments
 (0)