Leetcode
LC 278 & LC 374 & LC 704 & LC 852 LC 278 & LC 374 & LC 704 & LC 852
Solution to LeetCode 278 First Bad Version, LeetCode 374 Guess Number Higher or Lower, LeetCode 704 Binary Search, and L
2022-03-23 Search
Binary Search
LC 1173 & LC 1193 & LC 1211 & LC 1633 LC 1173 & LC 1193 & LC 1211 & LC 1633
The following basic-level SQL problems are about ‘Function’. Summarizing values by using SUM, AVG, with IF or conditions
2022-03-22 SQL
SQL-Basic
LC 1251 & LC 1445 & LC 1571 & LC 1699 LC 1251 & LC 1445 & LC 1571 & LC 1699
The following basic-level SQL problems are about ‘Function’. e.g. SUM() with IF conditions. LeetCode 1251Average Selling
2022-03-21 SQL
SQL-Basic
LC 1303 & LC 1308 & LC 1501 LC 1303 & LC 1308 & LC 1501
The following advanced-level SQL problems are about ‘Summary Function’. More: using LEFT to slice the string. LeetCode
2022-03-20 SQL
SQL-Advanced
LC 182 & LC 1050 & LC 1084 & LC 1587 LC 182 & LC 1050 & LC 1084 & LC 1587
The following intro-level SQL problems are about ‘Filtering (HAVING)’. LeetCode 182Duplicate Emails (Easy) [link] Using
2022-03-19 SQL
SQL-Intro
LC 1158 & LC 1393 & LC 1407 LC 1158 & LC 1393 & LC 1407
The following intro-level SQL problems are about ‘Control Flow’. LeetCode 1158Market Analysis I (Medium) [link] SELECT U
2022-03-18 SQL
SQL-Intro
LC 511 & LC 1141 & LC 1693 & LC 1729 & LC 1741 & LC 1890 LC 511 & LC 1141 & LC 1693 & LC 1729 & LC 1741 & LC 1890
The following intro-level SQL problems are about ‘Function (COUNT, MAX, MIN)’. LeetCode 511Game Play Analysis I (Easy)
2022-03-17 SQL
SQL-Intro
LC 175 & LC 197 & LC 607 & LC 1148 & LC 1581 LC 175 & LC 197 & LC 607 & LC 1148 & LC 1581
The following intro-level SQL problems are about ‘Join (JOIN or WHERE)’. Recall DATEDIFF, WHERE IS. Recall (INNER) JOIN
2022-03-16 SQL
SQL-Intro
LC 585 & LC 1484 & LC 1527 & LC 1667 & LC 2118 & LC 2199 LC 585 & LC 1484 & LC 1527 & LC 1667 & LC 2118 & LC 2199
The following intro-level SQL problems are about manipulating ‘string’ by GROUP_CONCAT, CONCAT, LEFT, RIGHT, SUBSTRING,
2022-03-15 SQL
SQL-Intro
LC 196 & LC 627 & LC 1873 LC 196 & LC 627 & LC 1873
The following intro-level SQL problems are about ‘ordering (ORDER BY)’ and ‘editing (CASE WHEN)’. More: DELETE and UPDAT
2022-03-14 SQL
SQL-Intro
LC 176 & LC 608 & LC 1795 & LC 1965 LC 176 & LC 608 & LC 1795 & LC 1965
The following intro-level SQL problems are about ‘combining (UNION) and querying’ and ‘selecting (HAVING)’. More: LIMIT
2022-03-13 SQL
SQL-Intro
LC 183 & LC 584 & LC 595 & LC 1757 LC 183 & LC 584 & LC 595 & LC 1757
The following intro-level SQL problems are about ‘selecting (WHERE)’. LeetCode 183Customers Who Never Order (Easy) [link
2022-03-12 SQL
SQL-Intro
12 / 18