TMTanmay Modhinmodhtanmay.hashnode.dev·Jan 18, 2025 · 5 min readSQL Interview Prep - Day 7Correcting Order Swapping Errors in Zomato's Delivery System Using SQL In the world of online food delivery, accuracy is paramount—whether it’s getting the right food to the right customer or ensuring that the order data is properly organized. But wh...00
TMTanmay Modhinmodhtanmay.hashnode.dev·Jan 18, 2025 · 7 min readSQL Window Functions: Detailed Examples with Real-Life Use CasesIn SQL, window functions allow you to perform operations across a set of rows related to the current row without collapsing the results. This is powerful for complex analyses like running totals, moving averages, ranking, etc., while keeping all the ...00
TMTanmay Modhinmodhtanmay.hashnode.dev·Jan 14, 2025 · 8 min readMastering SQL DATE FunctionsDates and times are an essential part of almost every database application. Whether you're working with transactions, event logging, or scheduling, you will frequently need to manipulate and query date and time data. SQL provides a rich set of functi...00
TMTanmay Modhinmodhtanmay.hashnode.dev·Jan 14, 2025 · 6 min readLeetCode - SQL 50 - Problem 22Calculating the Fraction of Players Who Logged In Consecutively Using SQL As user engagement becomes an increasingly important metric for online platforms, understanding how users interact with your application over time can provide valuable insights...00
TMTanmay Modhinmodhtanmay.hashnode.dev·Jan 11, 2025 · 5 min readSQL Interview Prep - Day 6In this article, we’ll walk through solving a SQL problem where we need to calculate the percentage of "immediate" orders from the first orders of all customers. The problem requires us to identify which orders are considered "immediate" based on the...00
