Section 01 : Select

Farahat612 · Farahat612 · commit be3f4d21fa9c · 2024-04-06T22:22:17.000+02:00
diff --git a/1. Select/01 1757. Recyclable and Low Fat Products.sql b/1. Select/01 1757. Recyclable and Low Fat Products.sql
@@ -0,0 +1 @@
+Select product_id from Products where low_fats = 'Y' and recyclable = 'Y'
diff --git a/1. Select/02 584. Find Customer Referee.sql b/1. Select/02 584. Find Customer Referee.sql
@@ -0,0 +1 @@
+Select name from Customer where referee_id is null or referee_id != 2
diff --git a/1. Select/03 595. Big Countries.sql b/1. Select/03 595. Big Countries.sql
@@ -0,0 +1 @@
+select name, population, area from World where area >= 3000000 or population >= 25000000
diff --git a/1. Select/04 1148. Article Views I.sql b/1. Select/04 1148. Article Views I.sql
@@ -0,0 +1 @@
+select distinct author_id as id from Views where author_id = viewer_id order by author_id 
diff --git a/1. Select/05 1683. Invalid Tweets.sql b/1. Select/05 1683. Invalid Tweets.sql
@@ -0,0 +1 @@
+select tweet_id from tweets where LENGTH(content) > 15

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1 @@`
	`1`	`+Select product_id from Products where low_fats = 'Y' and recyclable = 'Y'`
Original file line number	Diff line number	Diff line change
`@@ -0,0 +1 @@`
	`1`	`+Select name from Customer where referee_id is null or referee_id != 2`
Original file line number	Diff line number	Diff line change
`@@ -0,0 +1 @@`
	`1`	`+select name, population, area from World where area >= 3000000 or population >= 25000000`
Original file line number	Diff line number	Diff line change
`@@ -0,0 +1 @@`
	`1`	`+select distinct author_id as id from Views where author_id = viewer_id order by author_id`
Original file line number	Diff line number	Diff line change
`@@ -0,0 +1 @@`
	`1`	`+select tweet_id from tweets where LENGTH(content) > 15`