Sub-queries vs Window Functions vs Common Table Expressions: Which Should You Use in SQL?

SQL is the most used tool for data manipulation but what happens when there are some concepts that...