Leetcode
LC 1070 & LC 1112 & LC 1285 & LC 1951 LC 1070 & LC 1112 & LC 1285 & LC 1951
Solution to LeetCode about ‘window function’. LeetCode 1070Product Sales Analysis III (Medium) [link] SELECT product_id,
2022-04-28 SQL
Window Functions
LC 586 & LC 1076 & LC 1082 & LC 1204 LC 586 & LC 1076 & LC 1082 & LC 1204
Solution to LeetCode about ‘window function’ integrated with summary. LeetCode 586Customer Placing the Largest Number of
2022-04-27 SQL
Window Functions
LC 279 & LC 322 LC 279 & LC 322
Solution to LeetCode 322 Coin Change and LeetCode 279 Perfect Squares. LeetCode 322Coin Change (Medium) [link] This is a
2022-04-26 Dynamic Programming
Dynamic Programming Knapsack Problem
LC 518 & LC 377 (with template) LC 518 & LC 377 (with template)
Solution to LeetCode 518 Coin Change II and LeetCode 377 Combination Sum IV. LeetCode 518Coin Change II (Medium) [link]
2022-04-25 Dynamic Programming
Template Dynamic Programming Knapsack Problem
LC 474 & LC 494 (with template) LC 474 & LC 494 (with template)
Solution to LeetCode 474 Ones and Zeros and LeetCode 494 Target Sum LeetCode 474Ones and Zeros (medium) [link] This pro
2022-04-24 Dynamic Programming
Template Dynamic Programming Knapsack Problem
LC 416 & LC 1049 LC 416 & LC 1049
Solution to LeetCode 416 Partition Equal Subset Sum and LeetCode 1049 Last Stone Weight II. LeetCode 416Partition Equal
2022-04-23 Dynamic Programming
Dynamic Programming Knapsack Problem
LC 2153 & LC 2173 & LC 2199 LC 2153 & LC 2173 & LC 2199
The following advanced-level SQL problems. LeetCode 2153*The Number of Passengers in Each Bus II (Hard) [link] Idea:
2022-04-22 SQL
SQL-Advanced
LC 1919 & LC 1972 & LC 2004 & LC 2010 & LC 2118 LC 1919 & LC 1972 & LC 2004 & LC 2010 & LC 2118
The following advanced-level SQL problems. LeetCode 1919Leetcodify Similar Friends (Hard) [link] SELECT DISTINCT l1.use
2022-04-21 SQL
SQL-Advanced
LC 1479 & LC 1645 & LC 1651 & LC 1892 & LC 1917 LC 1479 & LC 1645 & LC 1651 & LC 1892 & LC 1917
The following advanced-level SQL problems. LeetCode 1479Sales by Day of the Week (Hard) [link] Idea: use dayofweek to d
2022-04-20 SQL
SQL-Advanced
LC 343 & LC 96 LC 343 & LC 96
Solution to LeetCode 343 Integer Break and LeetCode 96 Unique Binary Search Trees LeetCode 343Integer Break (Medium) [li
2022-04-19 Dynamic Programming
Dynamic Programming
LC 262 & LC 571 & LC 1369 & LC 1412 LC 262 & LC 571 & LC 1369 & LC 1412
The following advanced-level SQL problems. LeetCode 262Trips and Users (Hard) [link] SELECT request_at AS Day, ROUND(SU
2022-04-18 SQL
SQL-Advanced
LC 1159 & LC 1194 & LC 1225 LC 1159 & LC 1194 & LC 1225
The following advanced-level SQL problems. LeetCode 1159Market Analysis II (Hard) [link] SELECT u.user_id AS seller_id,
2022-04-17 SQL
SQL-Advanced
9 / 18