AnkitBasics of Window FunctionsThe query SELECT SUM(amount) FROM Orders; simply returns the total amount of all orders in the Orders table.Jan 17Jan 17
AnkitSolving LeetCode SQL Problem 172: Nth Highest SalaryYou can find the problem on LeetCode’s website at this link. The problem statement is as follows:Jan 9Jan 9
AnkitSolving LeetCode SQL Problem 511: Game PlayAnalysis 2You can find the problem on LeetCode’s website at this link. The problem statement is as follows:Jan 6Jan 6
AnkitSolving LeetCode SQL Problem 511: Game PlayAnalysis 1You can find the problem on LeetCode’s website at this link. The problem statement is as follows:Jan 6Jan 6
AnkitSolving LeetCode SQL Problem 1083: Sales Analysis 3You can find the problem on LeetCode’s website at this link. The problem statement is as follows:Jan 6Jan 6
AnkitSolving LeetCode SQL Problem 1083: Sales Analysis 2You can find the problem on LeetCode’s website at this link. The problem statement is as follows:Jan 6Jan 6
AnkitSolving LeetCode SQL Problem 1082: Sales Analysis 1You can find the problem on LeetCode’s website at this link. The problem statement is as follows:Jan 6Jan 6
AnkitSolving LeetCode SQL Problem 183: Customers Who Never OrderIn this article, we will address LeetCode problem 183, “Customers Who Never Order.” The goal is to find customers who have never placed an…Oct 20, 2023Oct 20, 2023
AnkitSolving LeetCode SQL Problem 182: Find Duplicate EmailsProblem DescriptionOct 20, 2023Oct 20, 2023