Leetcode
LC 618 & LC 1179 & LC 1777 LC 618 & LC 1179 & LC 1777
The following advanced-level SQL problems. Focusing on reshaping tables. LeetCode 618Students Report by Geography (Hard)
2022-04-16 SQL
SQL-Advanced
LC 569 & LC 615 & LC 1097 LC 569 & LC 615 & LC 1097
The following advanced-level SQL problems. LeetCode 569Median Employee Salary (Hard) [link] If the occurrence is odd, me
2022-04-15 SQL
SQL-Advanced
LC 1127 & LC 1635 & LC 1767 LC 1127 & LC 1635 & LC 1767
The following advanced-level SQL problems are about ‘Recursion, Dependency, Nesting’. Focusing on creating new tables. L
2022-04-14 SQL
SQL-Advanced
LC 1204 & LC 1205 & LC 1241 LC 1204 & LC 1205 & LC 1241
The following basic-level SQL problems. LeetCode 1204Last Person to Fit in the Bus (Medium) [link] SELECT person_name FR
2022-04-13 SQL
SQL-Basic
LC 1107 & LC 1113 & LC 1132 & LC 1149 LC 1107 & LC 1113 & LC 1132 & LC 1149
The following basic-level SQL problems. LeetCode 1107New Users Daily Count (Medium) [link] SELECT login_date, COUNT(*) A
2022-04-12 SQL
SQL-Basic
LC 39 & LC 40 (with template) LC 39 & LC 40 (with template)
Solution to LeetCode 39 Combination Sum, LeetCode 40 Combination Sum II. LeetCode 39Combination Sum (Medium) [link] Note
2022-04-11 Recursion
Template Backtracking
LC 1075 & LC 1083 & LC 1098 LC 1075 & LC 1083 & LC 1098
The following basic-level SQL problems. LeetCode 1075Project Employees I (Easy) [link] SELECT p.project_id, ROUND(AVG(e.
2022-04-10 SQL
SQL-Basic
LC 17 & LC 77 & LC 216 LC 17 & LC 77 & LC 216
Solution to LeetCode 17 Letter Combinations of a Phone Number, LeetCode 77 Combinations, and LeetCode 216 Combination Su
2022-04-09 Recursion
Backtracking
LC 610 & LC 614 & LC 1068 & LC 1069 LC 610 & LC 614 & LC 1068 & LC 1069
The following basic-level SQL problems. LeetCode 610Triangle Judgement (Easy) [link] Using CASE WHEN SELECT x, y, z,
2022-04-08 SQL
SQL-Basic
LC 577 & LC 585 & LC 597 & LC 602 LC 577 & LC 585 & LC 597 & LC 602
The following basic-level SQL problems. LeetCode 577Employee Bonus (Easy) [link] SELECT e.name, b.bonus FROM Employee e
2022-04-07 SQL
SQL-Basic
LC 1336 & LC 1384 & LC 1613 & LC 1635 & LC 1645 & LC 1651 & LC 1767 LC 1336 & LC 1384 & LC 1613 & LC 1635 & LC 1645 & LC 1651 & LC 1767
The following advanced-level SQL problems are about ‘Recursion, Dependency, Nesting’. Focusing on creating new tables. L
2022-04-06 SQL
SQL-Advanced
LC 1532 & LC 1831 & LC 1949 LC 1532 & LC 1831 & LC 1949
The following advanced-level SQL problems are about ‘Function’. LeetCode 1532The Most Recent Three Orders (Medium) [link
2022-04-05 SQL
SQL-Advanced
10 / 18