tcv-tclsbc
diff --git a/‎Readme.md
Lines changed: 69 additions & 0 deletions b/‎Readme.md
Lines changed: 69 additions & 0 deletions
@@ -0,0 +1,69 @@
+1757 - Recyclable and Low Fat Products
+```sql
+SELECT product_id
+FROM Products
+WHERE low_fats = 'Y'
+AND recyclable = 'Y'
+```
+---
+
+584 - Find Customer Referee
+```sql
+SELECT name 
+FROM Customer 
+WHERE referee_id != 2 OR referee_id IS null
+```
+
+595 - Big Countries
+```sql
+SELECT name, population, area
+FROM WORLD
+WHERE area >= 3000000
+OR population >= 25000000
+```
+
+1148 - Article Views I
+```sql
+SELECT DISTINCT author_id as id
+FROM Views
+WHERE viewer_id >= 1
+AND author_id = viewer_id
+ORDER BY author_id
+```
+
+1683 - Invalid Tweets
+```sql
+SELECT tweet_id
+FROM Tweets
+WHERE length(content) > 15
+```
+
+1378 - Replace Employee ID With The Unique 
+Identifier
+```sql
+SELECT unique_id, name
+FROM Employees e
+LEFT JOIN EmployeeUNI eu
+ON e.id = eu.id
+```
+
+1068 - Product Sales Analysis I
+```sql
+SELECT product_name, year, price
+FROM Sales s
+LEFT JOIN Product p
+ON s.product_id = p.product_id
+```
+
+1581 - Customer Who Visited but Did Not Make Any Transactions
+```sql
+SELECT customer_id, COUNT(*) as count_no_trans
+FROM Visits 
+WHERE visit_id NOT IN (SELECT DISTINCT visit_id FROM Transactions)
+GROUP BY customer_id
+```
+
+
+
+
+