29 docs tagged with "Leetcode SQL Solutions for Medium Problems"

LeetCode SQL Solution of Problem 1045. Customers Who Bought All Products. GROUP BY + HAVING Solution.

LeetCode SQL Solution of Problem 1070. Product Sales Analysis III. CTE + GROUP BY Solution.

LeetCode SQL Solution of Problem 1077. Project Employees III. Use RANK() Window Function to rank most experience employees in each project as 1

LeetCode SQL Solution of Problem 1098. Unpopular Books. GROUP BY + HAVING + LEFT JOIN Solution.

LeetCode SQL Solution of Problem 1107. New Users Daily Count. Solved Using Subquery and Count DISTINCT!

LeetCode SQL Solution of Problem 1112. Highest Grade For Each Student. RANK() Window Function Solution + CTE and Group By Solution.

LeetCode SQL Solution of Problem 1126. Active Businesses. AVG() Window Function Solution + Group By CTE Solution!

LeetCode SQL Solution of Problem 1132. Reported Posts II. Implemetation of LEFT JOIN and Count Solution!

LeetCode SQL Solution of Problem 1149. Article Views II. Implementation of Group By, Count DISTINCT, and CTE Solution!

LeetCode SQL Solution of Problem 1158. Market Analysis I. Simple and Efficient LEFT JOIN Solution!

[SOLVED with 3 Different Implementations] LeetCode SQL Solution of Problem [1264. Page Recommendations].

LeetCode SQL Solution of Problem [1445. Apples and Oranges]. 3 Different Approaches - Self Join, Pivot Data with CASE Statements, and Built-In PIVOT Operator.

LeetCode SQL Solution of Problem 177. Nth Highest Salary. Dense_Rank() Window Function Solution + Correlated Subquery Solution.

LeetCode SQL Solution of Problem 178. Rank Scores. Dense_Rank() Window Function Solution + Correlated Subquery Solution.

LeetCode SQL Solution of Problem [180. Consecutive Numbers]. Self Join Approach + Window Function Approach Lag() and Lead() Explained.

LeetCode SQL Solution of Problem 184. Department Highest Salary. Multiple Solutions Including RANK() Window Function.

Implementation utilizing Self Join, CTE, and Subquery Techniques. LeetCode SQL Solution of Problem [2084. Drop Type 1 Orders for Customers with Type 0 Orders].

LeetCode SQL Solution of Problem 534. Game Play Analysis III. Correlated Subquery, Self Join, and SUM() Window Function Solutions.

LeetCode SQL Solution of Problem 550. Game Play Analysis IV. Common Table Expression Implementation.

LeetCode SQL Solution of Problem 570. Managers with at Least 5 Direct Report. CTE Implementation.

LeetCode SQL Solution of Problem 574. Winning Candidate. MySQL LIMIT and SQL Server TOP Implementation.

LeetCode SQL Solution of Problem 578. Get Highest Answer Rate Question. Simple CTE Solution!

LeetCode SQL Solution of Problem 580. Count Student Number in Departments. Simple LEFT JOIN Solution.

LeetCode SQL Solution of Problem 585. Investments in 2016. Subquery and CTE with LEFT JOIN Solutions

LeetCode SQL Solution of Problem 602. Friend Requests II: Who Has the Most Friends. Subquery + UNION ALL Solution.

LeetCode SQL Solution of Problem 608. Tree Node. Self Join + Union Solution.

LeetCode SQL Solution of Problem 612. Shortest Distance in a Plane. Solution Using MIN(), SQRT(), POWER(), and CAST() Functions.

LeetCode SQL Solution of Problem 614. Second Degree Follower. Simple INNER SELF JOIN Solution.

LeetCode SQL Solution of Problem 626. Exchange Seats. SELF LEFT JOIN Implementation.