15 docs tagged with "Leetcode SQL Solutions for Easy Problems"

LeetCode SQL Solution of Problem 175. Combine Two Tables. LEFT JOIN Solution.

LeetCode SQL Solution of Problem 176. Second Highest Salary. Rank() Window Function Solution + Limit Offset Solution.

Solved with Self Join Technique - LeetCode SQL Solution of Problem 181. Employees Earning More Than Their Managers.

Solved with [Self Join] or [Group By]+[Having] Techniques - LeetCode SQL Solution of Problem 182. Duplicate Emails

LeetCode SQL Solution of Problem 183. Customers Who Never Order.

LeetCode SQL Solution of Problem 196. Delete Duplicate Emails.

LeetCode SQL Solution of Problem [1965. Employees With Missing Information]. Combines the results of two queries using the UNION operator.

Two Solultions - Self Join Solution + Lag() Window Function Solution - Problem 197. Rising Temperature.

LeetCode SQL Solution of Problem [1978. Employees Whose Manager Left the Company]. Using SELF JOIN and LEFT JOIN Techniques.

LeetCode SQL Solution of Problem #511. Game Play Analysis I. Group By + Min() Solution.

[Solved!!!] First_Value() Window Function Implementation + Group By with Common Table Expression Implementation. LeetCode SQL Solution of Problem 512. Game Play Analysis II.

SQL Solution - The combination of the LEFT JOIN operation and the WHERE conditions ensures that the query retrieves employee names and their corresponding bonus amounts if the bonus is less than 1000 or if no bonus record exists for the employee.

LeetCode SQL Solution of Problem [584. Find Customer Referee].

SQL Solution - Group the orders based on customer numbers, count the number of orders for each customer, order the groups in descending order by the order count, and then limit the result to only one row.

LeetCode SQL Solution of Problem [603. Consecutive Available Seats].