Tag: Group By

SQL Hacks To Control Family Budget On Black Friday Weekend

Tags

data analysis
extras
GROUP BY
how to in sql
join
reporting with SQL
SQL basics

November 23, 2017

sql basics, how to in sql, JOIN, GROUP BY, reporting with SQL, data analysis, extras,

If you’re in the US, chances are you’ve been eagerly awaiting the approach of Black Friday just as much as Thanksgiving. Though the shopping frenzy takes hold of nearly everyone, some people have to stick to their budgets and shop prudently. In this article, we’ll take a look at how generating an SQL report can help you track how much your family spent shopping on Black Friday. Storing Black Friday Purchases in a Database Before we can create an SQL report, we first need some data we can use.