Queries from my daily work

Website containing various SQL Challenges from my daily work as a Data Analyst

How To: Group by & Window Functions Together

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

Following users' funds and possible money layering using a recursive CTE

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

Text Manipulation & RegEx in a Data Analysis Flow (with examples in SQL vs Python/R)

Going over various cases of text operations in a data analysis flow, showing how to solve it with R/Python compared to SQL.