A short overview of how to use window functions within a group by query. Going over 3 examples that help illustrate how to combine the two, as well as a better understanding the order of opertaions in SQL
Though not commonly used, recursive CTEs can be a great tool to work with hierarchal formatted data. In this post we learn to use them to identify where money was moved to by following users transfer activities
Going over various cases of text operations in a data analysis flow, showing how to solve it with R/Python compared to SQL.
Solving an SQL interview question using three different approaches.