8 docs tagged with "Leetcode SQL Solutions for Hard Problems"

LeetCode 185. Department Top Three Salaries SQL Solution

Unlock the Solution to LeetCode Problem 185 - Department Top Three Salaries with These 4 SQL Solutions!

LeetCode 1919. Leetcodify Similar Friends SQL Solution

LeetCode SQL Solution of Problem 1919. Leetcodify Similar Friends.

LeetCode 1972. First and Last Call On the Same Day SQL Solution

LeetCode SQL Solution of Problem 1972. First and Last Call On the Same Day. RANK() Window Function Implementation.

LeetCode 2004. The Number of Seniors and Juniors to Join the Company SQL Solution

LeetCode SQL Solution of Problem 2004. The Number of Seniors and Juniors to Join the Company. SUM() Window Function Solution.

LeetCode 2199. Finding the Topic of Each Post SQL Solution

LeetCode SQL Solution of Problem [2199. Finding the Topic of Each Post]. Solved using Recursive CTE, CHAR_LENGTH(), REPLACE(), SUBSTRING_INDEX(), and GROUP_CONCAT() functions.

LeetCode 262. Trips and Users SQL Solution

LeetCode SQL Solution of Problem 262. Trips and Users. Solved with CTE, Group By, and CASE WHEN Statement.

LeetCode 569. Median Employee Salary SQL Solution

LeetCode SQL Solution of Problem 569. Median Employee Salary.

LeetCode 601. Human Traffic of Stadium SQL Solution

LeetCode SQL Solution of Problem 601. Human Traffic of Stadium. Row_Number() Window Function Solution + Cross Join Solution.