GitHub - nabed67/leetcode-sql-50: LeetCode SQL 50 Journey - Learning SQL Select, Joins, Aggregations, Subqueries, and Advanced Functions.

1757. Recyclable and Low Fat Products

I have solved first LeetCode MySQL problem from the SQL 50 challenge. While solving this problem I have learned how to write queries & select specific columns from a table.

584. Find Customer Referee

IS NULL checks for NULL values, while != checks for values that are not equal

595. Big Countries

ORDER BY sorts the query results in ascending (ASC) or descending (DESC) order

1148. Article Views I

ORDER BY sorts the query results in ascending (ASC) or descending (DESC) order

1683. Invalid Tweets

LENGTH() function returns the number of characters in a string

Name		Name	Last commit message	Last commit date
1-recyclable-and-low-fat-products.sql		1-recyclable-and-low-fat-products.sql
10-average-time-of-process.sql		10-average-time-of-process.sql
11-employee-bonus.sql		11-employee-bonus.sql
12-students-and-examinations.sql		12-students-and-examinations.sql
13-managers-with-at-least-5.sql		13-managers-with-at-least-5.sql
14-confirmation-rate.sql		14-confirmation-rate.sql
15-not-boring-movies.sql		15-not-boring-movies.sql
16-average-selling-price.sql		16-average-selling-price.sql
17-project-employees-i.sql		17-project-employees-i.sql
18-percentage-of-users-attended.sql		18-percentage-of-users-attended.sql
19-queries-quality-and-percentage.sql		19-queries-quality-and-percentage.sql
2-find-customer-referee.sql		2-find-customer-referee.sql
20-monthly-transactions-i.sql		20-monthly-transactions-i.sql
21-immediate-food-delivery-ii.sql		21-immediate-food-delivery-ii.sql
22-game-play-analysis-iv.sql		22-game-play-analysis-iv.sql
23-number-of-unique-subjects.sql		23-number-of-unique-subjects.sql
24-user-activity-for-the-past-30-days.sql		24-user-activity-for-the-past-30-days.sql
25-product-sales-analysis-iii.sql		25-product-sales-analysis-iii.sql
26-classes-with-at-least-5.sql		26-classes-with-at-least-5.sql
26-find-followers-count.sql		26-find-followers-count.sql
27-biggest-single-number.sql		27-biggest-single-number.sql
28-customers-who-bought-all-products.sql		28-customers-who-bought-all-products.sql
29-the-number-of-employees.sql		29-the-number-of-employees.sql
3-big-countries.sql		3-big-countries.sql
30-primary-department-for-each-employee.sql		30-primary-department-for-each-employee.sql
31-triangle-judgement.sql		31-triangle-judgement.sql
32-consecutive-numbers.sql		32-consecutive-numbers.sql
33-product-price-at-a-given-date.sql		33-product-price-at-a-given-date.sql
34-last-person-to-fit-in-the-bus.sql		34-last-person-to-fit-in-the-bus.sql
35-count-salary-categories.sql		35-count-salary-categories.sql
36-employees-whose-manager-left.sql		36-employees-whose-manager-left.sql
37-exchange-seats.sql		37-exchange-seats.sql
38-movie-rating.sql		38-movie-rating.sql
39-restaurant-growth.sql		39-restaurant-growth.sql
4-article-views-i.sql		4-article-views-i.sql
40-friend-requests-ii.sql		40-friend-requests-ii.sql
41-investments-in-2016.sql		41-investments-in-2016.sql
43-fix-names-in-a-table.sql		43-fix-names-in-a-table.sql
5-invalid-tweets.sql		5-invalid-tweets.sql
6-replace-employee-id.sql		6-replace-employee-id.sql
7-product-sales-analysis.sql		7-product-sales-analysis.sql
8-customer-who-visited.sql		8-customer-who-visited.sql
9-rising-temperature.sql		9-rising-temperature.sql
README.md		README.md

Navigation Menu

Repository files navigation

1757. Recyclable and Low Fat Products

584. Find Customer Referee

595. Big Countries

1148. Article Views I

1683. Invalid Tweets

1378. Replace Employee ID With The Unique Identifier

About

Releases

Packages

Contributors

Latest commit

History

Folders and files

Repository files navigation

1757. Recyclable and Low Fat Products

584. Find Customer Referee

595. Big Countries

1148. Article Views I

1683. Invalid Tweets

1378. Replace Employee ID With The Unique Identifier

About

Topics

Resources

Stars

Watchers

Forks

Releases

Packages

Contributors