This article is a guide on using SQL window functions in applications that need to make computational heavy queries. Data is proliferating at an astonishing rate. In 2022, the world produced and consumed 94 zetabytes of data. Today we have multiple tools like Hive and Spark to handle Big Data. Even though the tools differ in the types of problems they were designed to solve, they employ the fundamentals of SQL, which makes it slightly easier for people to work with big data. Window functions are an example of one such SQL concept. It is a must know for software
