Solution to LeetCode about ‘window function’. LeetCode 1070Product Sales Analysis III (Medium) [link] SELECT product_id,

Solution to LeetCode about ‘window function’ integrated with summary. LeetCode 586Customer Placing the Largest Number of

Solution to LeetCode 322 Coin Change and LeetCode 279 Perfect Squares. LeetCode 322Coin Change (Medium) [link] This is a

Solution to LeetCode 518 Coin Change II and LeetCode 377 Combination Sum IV. LeetCode 518Coin Change II (Medium) [link]

Solution to LeetCode 474 Ones and Zeros and LeetCode 494 Target Sum LeetCode 474Ones and Zeros (medium) [link] This pro

Solution to LeetCode 416 Partition Equal Subset Sum and LeetCode 1049 Last Stone Weight II. LeetCode 416Partition Equal

The following advanced-level SQL problems. LeetCode 2153*The Number of Passengers in Each Bus II (Hard) [link] Idea:

The following advanced-level SQL problems. LeetCode 1919Leetcodify Similar Friends (Hard) [link] SELECT DISTINCT l1.use

The following advanced-level SQL problems. LeetCode 1479Sales by Day of the Week (Hard) [link] Idea: use dayofweek to d

Solution to LeetCode 343 Integer Break and LeetCode 96 Unique Binary Search Trees LeetCode 343Integer Break (Medium) [li

The following advanced-level SQL problems. LeetCode 262Trips and Users (Hard) [link] SELECT request_at AS Day, ROUND(SU

The following advanced-level SQL problems. LeetCode 1159Market Analysis II (Hard) [link] SELECT u.user_id AS seller_id,