SQL Common Table Expressions and Window functions

Sometimes when writing queries for reporting purposes, the queries required to manipulate the data can get complex.

If you are able to use PHP or Python to manipulate the data after running a query, then the query required to get the desired result is much simpler.

But sometimes you just have to find a way to fetch the data you need using only a SQL query.

For the purposes of this article, the desired outcome from the query is to …

data database datascience functions mysql php python query reporting running sql table writing